MySQL Tutorial/Date Time Functions/DATE
DATE(expr) Extracts the date part of the date or datetime expression expr.
<source lang="sql">
mysql> mysql> SELECT DATE("2003-12-31 01:02:03"); +-----------------------------+ | DATE("2003-12-31 01:02:03") | +-----------------------------+ | 2003-12-31 | +-----------------------------+ 1 row in set (0.00 sec) mysql></source>