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

Parameter	Description
<date_or_time_part>	A valid date expression of type datetime, supporting datetime. For specific datetime and date formats, please refer to datetime 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       |
+------------+