Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

SELECT DATEDIFF(yy, Dec 31, 1998, Jan 1, 1999)

3>  SELECT DATEDIFF(yy, 'Dec 31, 1998', 'Jan 1, 1999') 4> GO -----------           1 (1 rows affected)