Example
Extract the date part:
sql
SELECT DATE("2017-06-15");
Definition and Usage
The DATE() function extracts the date part from a datetime expression.
Syntax
text
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:
sql
SELECT DATE("2017-06-15 09:34:21");
Example
Extract the date part (will return NULL):
sql
SELECT DATE("The
date is 2017-06-15");
Example
Extract the date part:
sql
SELECT DATE(OrderDate) FROM Orders;