Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

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

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