date « sql « C Q&A

1. mysql WHERE '2010-08-24 11:59:59' BETWEEN c.start_date AND c.end_date;    stackoverflow.com

I'm currently trying to use this query

SELECT 
a.id AS id,
a.item AS item,
c.id AS campaign_id,
DATE(c.start_date) AS START,
DATE(c.end_date) AS END
FROM campaign c LEFT JOIN action_6 a
ON c.id = a.campaign_id WHERE action_id ...

2. Embedded SQL in C program -- Getting Date Value    forums.devshed.com

3. What datatype can be used to store the SQL type DATE?    forums.devshed.com

__________________ The essence of Christianity is told us in the Garden of Eden history. The fruit that was forbidden was on the Tree of Knowledge. The subtext is, All the suffering you have is because you wanted to find out what was going on. You could be in the Garden of Eden if you had just kept your f***ing mouth shut ...