MONTH (Transact-SQL)
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, see Date and Time Data Types and Functions (Transact-SQL). Applies to: SQL Server (SQL Server 2008 through curr...