DATE INCREASE AND DECREASE LIKE ONE MONTH, WEEK AND DAY IN SQL SERVER

Query :  Incrementing datepart by an interval of 1



SELECT 'week',DATEADD(week,1,getdate())   ---- Add one week

SELECT 'month',DATEADD(month,1,getdate()) ---- Add one month

SELECT 'day',DATEADD(day,1,getdate())  ---- Add one day


Query :  Decrementing datepart by an interval of 1



SELECT 'week',DATEADD(week,-1,getdate())   ---- Minus one week

SELECT 'month',DATEADD(month,-1,getdate()) ---- Minus one month

SELECT 'day',DATEADD(day,-1,getdate())  ---- Minus one day