Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

Select DATENAME(week, 2002-09-30 11

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