Loading lesson path
Concept visual
Start at both ends
Return the day of the month for a date:
SELECT DAYOFMONTH("2017-06-15");The DAYOFMONTH() function returns the day of the month for a given date (a number from 1 to 31).
This function equals the DAY() function.
date )
Required. The date to extract the day from
From MySQL 4.0
Return the day of the month for a date: SELECT DAYOFMONTH("2017-06-15 09:34:21");
Return the day of the month for the current system date:
SELECT DAYOFMONTH(CURDATE());❮ MySQL Functions