Date Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Date Functions
  4. 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)