Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

DATE

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:

SQL

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

Examples

SQL

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