How to add years to date in SQL?
sql, sql-server
Solution
`DateAdd()` is the function you want http://technet.microsoft.com/en-us/library/ms186819.aspx
SELECT DateAdd(yy, 2, Cast(d As datetime))
Problem
How to add 2 years to date in SQL. ``` select left(cast(D as datetime) ,11) from table ``` In the above query how can i add 2 years. Output is, ``` Jan 1 2012 Jan 2 2012 Jan 3 2012 Jan 4 2012 ``` but i want output as, ``` Jan 1 2014 Jan 2 2014 Jan 3 2014 Jan 4 2014 ``` Thank you