Returns the month part of a value. The argument must be a date, timestamp, date duration, or timestamp duration.
Example:
Select all rows from the EMPLOYEE table for people who were born (BIRTHDATE) in DECEMBER.
SELECT * FROM EMPLOYEE WHERE MONTH(BIRTHDATE) = 12