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