Date Functions MSSQL Tutorial

2>  select DATENAME(dayofyear, '2002-09-30 11:35:00')
3>
6> GO
------------------------------
273
(1 rows affected)