Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

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

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