Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

Difference in weeks between 7-2-1996 and 8-4-1997

1> -- Difference in weeks between 7-2-1996 and 8-4-1997? 2> 3> SELECT DATEDIFF(week, '7-2-1996', '8-4-1997') 4> GO -----------          57 (1 rows affected) 1>