Extract the date part from a datetime expression. This function returns the year, month, and day portions, discarding the time component.
SELECT DATE('2013-07-18 12:21:32');
+-----------------------------+
| DATE('2013-07-18 12:21:32') |
+-----------------------------+
| 2013-07-18 |
+-----------------------------+