Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

Select DATEDIFF(quarter, 2001-12-01, 2002-09-30)

2> 3> select DATEDIFF(quarter, '2001-12-01', '2002-09-30') 4> GO -----------           3 (1 rows affected)