MySQL DATE() Function

Extract the date part:

SELECT DATE("2017-06-15");

Definition and Usage

The DATE() function extracts the date part from a datetime expression.

DATE( expression)

Parameter	Description
expression	Required. A valid date/datetime value. Returns NULL if expression is not a date or a datetime

Works in:	From MySQL 4.0

Extract the date part:

SELECT DATE("2017-06-15 09:34:21");

Extract the date part (will return NULL):

SELECT DATE("The date is 2017-06-15");

Extract the date part:

SELECT DATE(OrderDate) FROM Orders;