Returns an integer that represents the month of the specified date.
For an overview of all Transact-SQL date and time data types and functions, seeDate and Time Data Types and Functions (Transact-SQL). For information and examples that are common to date and time data types and functions, see Using Date and Time Data.
MONTH returns the same value as DATEPART (month, date).
If date contains only a time part, the return value is 1, the base month.