Syntax

DATE (dateobj)

Arguments

• dateobj: a valid date, datetime, or parsable date string

Return Type

Date object. If dateobj is not a valid date, returns ERROR.

Remarks

The DATE function supports improved segment elimination when used in WHERE clauses. See the following query examples:

SELECT ... FROM table_name WHERE DATE(column_name) > '2020-01-01';  
SELECT ... FROM table_name WHERE DATE (column_name) > CURDATE() - 2;    

Examples

SELECT DATE('2019-01-01 05:06');

+--------------------------+
| DATE('2019-01-01 05:06') |
+--------------------------+
| 2019-01-01               |
+--------------------------+

Related Topics

• CURRENT_TIMESTAMP

• CURRENT_DATE And CURDATE

• Data Types