1> -- Add 12 years to 24th March 1964
2>
3> SELECT DATEADD(yy,12,"24 March 1964")
4>
5> SELECT DATEADD(yyyy,12,"24 March 1964")
6> GO
-----------------------
1976-03-24 00:00:00.000
(1 rows affected)
-----------------------
1976-03-24 00:00:00.000
(1 rows affected)
1>