Name

DATE()

Synopsis

DATE(expr)

Extracts the date part of the date or a DATETIME expression expr. This code returns the value “1961-05-02”:

SELECT DATE('1961-05-02 14:56:23');