MySQL:

DATE FUNCTION

Syntax:
DATE(expr)

Extracts the date part of the date or datetime expression expr.

mysql> SELECT DATE('2003-12-31 01:02:03');
-> '2003-12-31'

bottom of page