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