I have a table which contains a datetime column. I wish to return all records of a given day regardless of the time. Or in other words, if my table only contained the following 4 records, then only the 2nd and 3rd would be returned if I limit to 2012-12-25.
NEVER EVER use a selector like
DATE(datecolumns) = '2012-12-24' - it is a performance killer:
DATE()for all rows, including those, that don't match
It is much faster to use
SELECT * FROM tablename WHERE columname BETWEEN '2012-12-25 00:00:00' AND '2012-12-25 23:59:59'
as this will allow index use without calculation.