Javatpoint Logo
Javatpoint Logo

MySQL DATE() Function

The date() is a MySQL date/time function. It is used to get the date from given date/datetime.

Syntax

Parameter:

expression: date/datetime value to be extracted.

Returns

This function will return NULL if the expression is not a date or a datetime value.

Example 1

Output:


MySQL DATE() Function

Example 2

Output:


MySQL DATE() Function
Next TopicMySQL date/time




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA