Mega Code Archive
Categories
/
MSSQL
/
Date Timezone
Select DATENAME(dayofyear, 2002-09-30 11
2> select DATENAME(dayofyear, '2002-09-30 11:35:00') 6> GO ------------------------------ 273 (1 rows affected)