Adding 1 month to a date? 1

[RevelationUK]

In Sql, how do I add exactly 1 month to a date in the format mm/dd/yyyy ?

 

[makisbest]

what did you mean 1 month. Be more specific.

 

[RevelationUK]

as in, if i have CurrentDate = 1st Feb
and I add "1 month" it will return: 1st March

 

[mrdenny]

Use dateadd. This will return 1 month from today.

select convert(varchar(10), dateadd(mm, 1, getdate()), 101)

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[vongrunt]

> In Sql, how do I add exactly 1 month to a date in the format mm/dd/yyyy ?

mrdenny said everything, but I cannot resist: does this mean date is stored as string (char/varchar)?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[NotSQL]

1 month from today

select dateadd(m,+1, getdate())