Mega Code Archive
Categories
/
MSSQL Tutorial
/
Date Functions
Select DATEDIFF(week, 2001-12-01, 2002-09-30)
2> 3> select DATEDIFF(week, '2001-12-01', '2002-09-30') 4> GO ----------- 44 (1 rows affected)