Adding Time

[woyler]

Is there a way to add time intervals(not time of day) in the format of hh:mm:ss for use in a SP?
i.e.
01:20:10 + 2:30 = 01:22:40

Thanks,
Bill

 

[Cagliostro]

yes, see DateAdd(one of d/dd/y/yy/m/mm/,date,dateToAdd) John Fill

ivfmd@mail.md

 

[woyler]

Please correct me if I am wrong, but the arguments for DateAdd are DateAdd(datepart,number,date)
Say I am adding:
26:20:10 (26 hours,20mins,10sec)
+10:10:10 (10hours,10mins,10sec)
total: 36:30:10 (36hours,30mins,10sec)

Doesn't the DateAdd function use a 12 or 24 hour time base? The date part requirement could be used only for on part of the time I am adding, and the number parameter needs to be a whole number to add to the specified 'datepart'
So DateAdd("hh","mm","ss",26:20:10,10:10:10) or any variation thereof will not work.

 

[Cagliostro]

No,
use one of DateAdd(ss,yourDate,numberOfCeconds)
DateAdd(s,yourDate,numberOfCeconds)
DateAdd(second,yourDate,numberOfCeconds) wher you want to add seconds
hh/h/hour for hours and ..., without "" John Fill

ivfmd@mail.md

 

[woyler]

How would you suggest working out the problem of when the sum is more than 59. 00:01:58 + 00:02:54

 

[Cagliostro]

It'll automadically be added 1 to minutes:
--query
declare @xxx datetime
set @xxx = (select GetDate())
print @xxx
set @xxx = (select dateadd(s, 58, @xxx))
print @xxx
--result
Aug 10 2001 11:35PM
Aug 10 2001 11:36PM
John Fill

ivfmd@mail.md