DATE()

DATE() extracts the date part of the date or datetime

Example

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

Returns

2003-12-31

MySQL Date Functions
- ADDDATE()
- ADDTIME()
- CONVERT_TZ()
- CURDATE()
- CURRENT_DATE()
- CURRENT_TIME()
- CURRENT_TIMESTAMP()
- CURTIME()
- DATE_ADD()
- DATE_FORMAT()
- DATE_SUB()
- DATE()
- DATEDIFF()
- DAY()
- DAYNAME()
- DAYOFMONTH()
- DAYOFWEEK()
- DAYOFYEAR()
- EXTRACT
- FROM_DAYS()
- FROM_UNIXTIME()
- HOUR()
- LAST_DAY
- LOCALTIME()
- LOCALTIMESTAMP()
- MAKEDATE()
- MAKETIME
- MICROSECOND()
- MINUTE()
- MONTH()
- MONTHNAME()
- NOW()
- PERIOD_ADD()
- PERIOD_DIFF()
- QUARTER()
- SEC_TO_TIME()
- SECOND()
- STR_TO_DATE()
- SUBDATE()
- SUBTIME()
- SYSDATE()
- TIME_FORMAT()
- TIME_TO_SEC()
- TIME()
- TIMEDIFF()
- TIMESTAMP()
- TIMESTAMPADD()
- TIMESTAMPDIFF()
- TO_DAYS()
- UNIX_TIMESTAMP()
- UTC_DATE()
- UTC_TIME()
- UTC_TIMESTAMP()
- WEEK()
- WEEKDAY()
- WEEKOFYEAR()
- YEAR()
- YEARWEEK()