How to add days to date T-SQL

Add days

How to add days to date DATEADD function with getdate, sysdatetime, current_timestamp.

Examples

select dateadd(D, 1, '2018-01-06');

select dateadd(DD, 1, '2018-01-06');

select dateadd(DW, 1, '2018-01-06');

select dateadd(DY, 1, '2018-01-06');

select dateadd(DAY, 1, '2018-01-06');

select dateadd(DAYOFYEAR, 2, '2018-01-06');

select dateadd(WEEKDAY, 3, '2018-01-06');




select dateadd(DAY, 1, getdate());

select dateadd(DAY, 2, sysdatetime());

select dateadd(DAY, 3, current_timestamp);