Javatpoint Logo
Javatpoint Logo

MySQL DAY() Function

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

Syntax

Parameter:

date_value: date for getting day.

Returns

This function returns the day of the month (a number from 1 to 31) given a date value.

Example 1

Output:


MySQL DAY() Function

Example 2

Output:


MySQL DAY() Function
Next TopicMySQL date/time




Help Others, Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA