DATE

The DATE function returns the date part of the given expression.

Syntax

DATE(expression)

Example

SELECT DATE('2020-11-02 10:02:00')