How to calculate a date after 1 month currentDate

sql sql-server-2008 date

You can use DATEADD (datepart , number , date )

as specified here

Examples (thanks to DarrenDavis)

for month:

 select dateadd(m, 1, getdate())

for year:

 select dateadd(YY, 1, getdate())

sql sql-server-2008 date

Use the dateadd() function

SELECT dateadd(mm, 1, '19-Apr-2012')

sql sql-server-2008 date

To add 1 month to the current date:

SELECT DATEADD(m, 1, GETDATE())

To add 1 year to the current date:

SELECT DATEADD(YY, 1, GETDATE())

For additional arguments see:

CodeHunter