Important

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

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