1> -- Add 12 months to 24th March 1964
2>
3> SELECT DATEADD(m,12,"24 March 1964")
4>
5> SELECT DATEADD(mm,12,"24 March 1964")
6> GO
-----------------------
1965-03-24 00:00:00.000
(1 rows affected)
-----------------------
1965-03-24 00:00:00.000
(1 rows affected)
1>