Date Timezone MSSQL

  1. Home
  2. MSSQL
  3. Date Timezone
  4. 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>