Example
Return the month part of a date:
SELECT MONTH('2017/08/25') AS Month;
Definition and Usage
The MONTH() function returns the month part for a specified date (a number from 1 to 12).
Syntax
MONTH(date)
Return the month part of a date:
SELECT MONTH('2017/08/25') AS Month;
The MONTH() function returns the month part for a specified date (a number from 1 to 12).
MONTH(date)