Date Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Date Functions
  4. Select DATEADD(year, 1 5, 2002-09-30 11
2>
3> select  DATEADD(year, 1.5, '2002-09-30 11:35:00')
4> GO
-----------------------
2003-09-30 11:35:00.000
(1 rows affected)