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
 SQL Server 2000 Forums
 Transact-SQL (2000)
 add one day

Author  Topic 

wawansur
Starting Member

44 Posts

Posted - 2009-10-16 : 23:11:06
How to add 1 day in query from datetime data.

ex : 29 october 2009 + 1day ---> 30 october 2009

I'm nothing just gonna being

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-10-16 : 23:21:51
dateadd(day, 1, datecol)


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -