Date Functions MSSQL Tutorial

3>  select DATENAME(month,'2002-09-30')
4> GO
------------------------------
September
(1 rows affected)