Example

Extract the date part:

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

Definition and Usage

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

Syntax

DATE(expression)

Parameter Values

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

Technical Details

Works in: From MySQL 4.0

More Examples

Example

Extract the date part:

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

Example

Extract the date part (will return NULL):

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

Example

Extract the date part:

SELECT DATE(OrderDate) FROM Orders;


Login
ADS CODE