to_date
to_dateβ
descriptionβ
Syntaxβ
DATE TO_DATE(DATETIME)
Return 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