Re: Selecting all data of a specific date from mysql datetime

[Barry Galbraith]

http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_date

mysql> select now(), DATE(now());
+---------------------+-------------+
| now()               | DATE(now()) |
+---------------------+-------------+
| 2015-01-23 11:33:14 | 2015-01-23  |
+---------------------+-------------+
1 row in set (0.04 sec)

????

Good luck,
Barry.