Example
Return the day of the month for a date:
SELECT DAYOFMONTH("2017-06-15");
Definition and Usage
The DAYOFMONTH() function returns the day of the month for a given date (a number from 1 to 31).
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).