How to get Next month date from today date (i.e) exactly one month expires from today date

I have maintained two datas into my table

1 column 2 column PaidDate validitydate

in padidate ill give insert todaydate. but in validity date i may either inser开发者_如何学编程t validity for 1 week/1 month.

I have used validity=DATEADD(Day,7,@paiddate) to insert validity for 1 week. but how to gtet the validity for 1 month from todays date

Isn't that just:

validity = DATEADD(month, 1, @paiddate)

DATE_ADD supports units.