Date Functions MSSQL Tutorial

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