how to get Next month date from today date (i.e) exactely one month expires from today date

Question

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 insert 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

Answer 1

Isn't that just:

validity = DATEADD(month, 1, @paiddate)

Answer 2

DATE_ADD supports units.