Date Functions MSSQL Tutorial

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