Query to add one month to the current month

Question

How can add x number of months to the current month

I have tried below query but it didn't work

SELECT DateAdd(month,1,MONTH(GETDATE())) as Month

Out
put

1900-02-07 00:00:00.000

Answer 1

This will return the number for the next month.

select MONTH(DATEADD(MONTH, 1, GETDATE()))

Output:

7

Sign up