SQL Server/T-SQL Tutorial/Date Functions/MONTH

Displaying the Integer Value For Part of a Date using MONTH

3>
4> SELECT MONTH(GETDATE())
5> GO
-----------
         10
(1 rows affected)

select MONTH("2002-09-30")

3> select MONTH("2002-09-30")
4> GO
-----------
          9
(1 rows affected)