to_date

description

Syntax

DATE TO_DATE(DATETIME)

Return the DATE part of DATETIME value.

example

1. mysql> select to_date("2020-02-02 00:00:00");
2. +--------------------------------+
3. | to_date('2020-02-02 00:00:00') |
4. +--------------------------------+
5. | 2020-02-02                     |
6. +--------------------------------+

keywords

1. TO_DATE