Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

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

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