T-SQL Tutorial

How to add year to date T-SQL


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);