Name

MONTH()

Synopsis

MONTH(date)

Returns the month for date, in the range 1 through 12 for January through December. Dates that have a zero month part, such as “0000-00-00” or “2016-00-00,” return zero. This code returns the value 7:

SELECT MONTH('2016-07-11');