MONTH

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