Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Extracts the date part from a datetime object.
DATE (dateobj)
Date object. If dateobj is not a valid date, returns NULL.
select date('2019-01-01 05:06');
+--------------------------+
| date('2019-01-01 05:06') |
+--------------------------+
| 2019-01-01 |
+--------------------------+
Related Topics