Lynn Pettis (1/27/2010)

---

Like this?

declare @ TimeVal time,

@ TotalTime time; -- space added between @ and variable name to allow code to post

set @TimeVal = '08:05:44.0000000';

set @TotalTime = '00:13:00.0000000'

select @TimeVal,

@TotalTime,

dateadd(ss, ((DATEPART(HOUR,@TotalTime) * 60) + DATEPART(MINUTE,@TotalTime) * 60) + DATEPART(SECOND,@TotalTime), @TimeVal),

@TimeVal + @TotalTime;

i'm also doing something similar as to what you did here above but in my case i would like to know from you if it is possible to replace

@TimeVal = '08:05:44.0000000'; with @TimeVal = [RefreshIntervalColumn]

Because in my case is every records interval time is different, how do i go about it....

this is what im using DATEADD(s, RefreshIntervalSeconds, GETDATE())