Open In App

DAY() Function in MySQL

Improve
Improve
Like Article
Like
Save
Share
Report

DAY() function :
This function in MySQL is used to return the day of the month for a specified date (a number from 1 to 31). This function equals the DAYOFMONTH() function.

Syntax :

DAY(date)

Parameter :
This method accepts a parameter which is illustrated below :

  • date : Specified date to extract the day from.

Returns :
It returns the day of the month for a specified date (a number from 1 to 31).

Example-1 :
Getting the day of the month from a specified date “2020-11-24”.

SELECT DAY("2020-11-24"); 

Output :

24

Example-2 :
Getting the day of the month from a specified date “2020-11-22 07:12:23”.

SELECT DAY("2020-11-22 07:12:23");

Output :

22

Example-3 :
Getting the day of the month for the current system date.

SELECT DAY(CURDATE());

Output :

24

Application :
This function is used to return the day of the month for a specified date (a number from 1 to 31).


Last Updated : 02 Dec, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads