Date Functions MSSQL Tutorial

2>  select DATEPART(m,'2002-09-30')
3> GO
-----------
          9
(1 rows affected)
1>