to_date

docs/en/sql-reference/sql-functions/date-time-functions/to_date.md

4.1.0385 B

to_date

Converts a DATETIME value into a date.

Syntax

Haskell

DATE TO_DATE(DATETIME datetime)

Examples

Plain

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

keyword

TO_DATE