MySQL DATE() Function
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 (will return NULL):
SELECT DATE("The
date is 2017-06-15");
Try it Yourself »