DATE
Extracts the date part from a datetime object.
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 NULL.
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