SELECT DATE code example
Example 1: how to search date in sql query
select * from test
where date between '03/19/2014' and '03/19/2014 23:59:59'Example 2: mysql get date from datetime
WHERE DATE(datetime) = '2009-10-20'select * from test
where date between '03/19/2014' and '03/19/2014 23:59:59'WHERE DATE(datetime) = '2009-10-20'