THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL DATE() Function

❮ MySQL Functions

Example

Extract the date part:

SELECT DATE("2017-06-15");
Try it Yourself »

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");
Try it Yourself »

Example

Extract the date part (will return NULL):

SELECT DATE("The date is 2017-06-15");
Try it Yourself »

Example

Extract the date part:

SELECT DATE(OrderDate) FROM Orders;
Try it Yourself »

❮ MySQL Functions