Loading lesson path
Concept visual
Start at both ends
SELECT DATE("2017-06-15");The DATE() function extracts the date part from a datetime expression.
expression )
Formula
Required. A valid date/datetime value. Returns NULL if expression is not a date or a datetimeFrom MySQL 4.0
SELECT DATE("2017-06-15 09:34:21");
Extract the date part (will return NULL):
SELECT DATE("The date is 2017-06-15");SELECT DATE(OrderDate) FROM Orders;❮ MySQL Functions