Топ-100
 

DATE FUNCTION

База данных: MySQL
Текст

Syntax:
DATE(expr)

Extracts the date part of the date or datetime expression expr.

URL: https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html

Пример

mysql> SELECT DATE('2003-12-31 01:02:03');
-> '2003-12-31'