Adding And Subtracting Dates In T-SQL

This code will add 10 days to the current date:

@declare myDate datetime

set @myDate = (select dateadd(dd,10,getdate()))

select @myDate

This code will subtract one month from the passed in date:

@declare myDate datetime

set @myDate = (select dateadd(mm,-1,@dateArg))

select @myDate

Found at:

• http://www.java2s.com/Code/SQLServer/Date-Timezone/DATEADDaddorsubtractanumberofdaysmonthsoryearsfromaspecificdate.htm