Топ-100
 

DATE FUNCTION

RDBMS Type: MySQL
Topic

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

Example

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