Date Functions MSSQL Tutorial

5>  select DATENAME(week, '2002-09-30 11:35:00')
------------------------------
40
(1 rows affected)