Outdated Version

You are viewing an older version of this section. View current production version.

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.

Examples

select date('2019-01-01 05:06');
+--------------------------+
| date('2019-01-01 05:06') |
+--------------------------+
| 2019-01-01               |
+--------------------------+

Related Topics