I need to find results between a certain date (2009-04-24) and timestamp (2009-05-04 13:24:59). Both are in the same table. I'm not really sure how to specify the end. Below looks OK but is not correct...
SELECT *
FROM t1
WHERE startDate > 2009-04-24
AND endDateTime < '2009-05-04 13:24:59'
