Add year
How to add year to date DATEADD function with getdate, sysdatetime, current_timestamp.
Examples
select dateadd(Y, 1, '2018-01-06');
select dateadd(YY, 1, '2018-01-06');
select dateadd(YYYY, 1, '2018-01-06');
select dateadd(year, 1, '2018-01-06');
select dateadd(year, 2, '2018-01-06');
select dateadd(year, 1, getdate());
select dateadd(year, 2, sysdatetime());
select dateadd(year, 3, current_timestamp);