Is it possible to increment a datetime datatype?

[TomBarrand]

Does anyone know a method that will allow me to increment a datetime datatype in SQL Server 7? I need to increment a date by 1 each time. E.g. if 01/01/2001 is stored in the datebase I need the next one to be 02/01/2001

Thanks for your help.

Tom

 

[foxdev]

Sure, just add one to it. Try the following in QA:

[tt]declare @mydate datetime
set @mydate = getdate()
select @mydate, @mydate + 1[/tt]

Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org