Skip to main content

DATE

Description

The DATE function is used to extract the pure date part from a datetime value (which includes both date and time), ignoring the time information. This function can convert a DATETIME type into a DATE type, retaining only the year, month, and day information.

This function is consistent with the date function in MySQL.

Syntax

DATE(<date_or_time_part>)

Parameters

ParameterDescription
<date_or_time_part>A valid date expression of type datetime, supporting datetime. For specific datetime and date formats, please refer to datetime conversion and date conversion

Return Value

If the input is valid, it returns a pure date value of DATE type (in the format YYYY-MM-DD), without the time part. Special cases:

  • Returns NULL when the input is NULL;

Examples

-- Extract the date part from a datetime
mysql> select date(cast('2010-12-02 19:28:30' as datetime));
+-----------------------------------------------+
| date(cast('2010-12-02 19:28:30' as datetime)) |
+-----------------------------------------------+
| 2010-12-02 |
+-----------------------------------------------+

-- Extract the date part from a date
mysql> select date(cast('2015-11-02' as date));
+----------------------------------+
| date(cast('2015-11-02' as date)) |
+----------------------------------+
| 2015-11-02 |
+----------------------------------+

-- Input is NULL
mysql> select date(NULL);
+------------+
| date(NULL) |
+------------+
| NULL |
+------------+