add one to a date? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

add one to a date?

Author

Topic

jamios28
Starting Member

18 Posts

Posted - 2005-04-04 : 14:10:47

i think i found my error

how do i add one to a date? like ifs the 23, i want it to be the 24?

i tried this but i dont tink it works

@DateTemp = @DateTemp + 1

rfrancisco
Yak Posting Veteran

95 Posts

Posted - 2005-04-04 : 14:23:05

dateadd(d, 1, @DateTemp)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources