T-SQL Tutorial

How to add month to date T-SQL


Add month

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

Examples

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

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

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

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





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

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

select dateadd(month, 3, current_timestamp);