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>