Example
Return the month part of a date:
SELECT MONTH("2017-06-15");
Definition and Usage
The MONTH() function returns the month part for a given date (a number from 1 to 12).
Syntax
MONTH(date)
Return the month part of a date:
SELECT MONTH("2017-06-15");
The MONTH() function returns the month part for a given date (a number from 1 to 12).
MONTH(date)