VeloDB Cloud
SQL Manual
Functions
date-time-functions
to_date

to_date

Description

Syntax:

DATE TO_DATE(DATETIME)

This function returns the DATE part of DATETIME value.

Example

mysql> select to_date("2020-02-02 00:00:00");
+--------------------------------+
| to_date('2020-02-02 00:00:00') |
+--------------------------------+
| 2020-02-02                     |
+--------------------------------+

Keywords

TO_DATE