Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

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)