Example
Return the day of the month for a date:
SELECT DAY('2017/08/25') AS DayOfMonth;
Definition and Usage
The DAY() function returns the day of the month (from 1 to 31) for a specified date.
Syntax
DAY(date)
Return the day of the month for a date:
SELECT DAY('2017/08/25') AS DayOfMonth;
The DAY() function returns the day of the month (from 1 to 31) for a specified date.
DAY(date)