Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

Select DATEPART(quarter, 2002-09-30 11

3> select DATEPART(quarter, '2002-09-30 11:35:00') 4> GO -----------           3 (1 rows affected) 1>