Re: calculate the difference between two time stamps in hh:mm:ss

["Richard B Baird" <rbaird@xxxxxxxxxxxxxxxxxxxxx>]

Thanks Barbara,

I wasn't aware of the t'00.00.00' syntax.  what is the definition of your
time field?  is it a time data type?

This won't be a problem in my case, but what happens if the difference
between the two time stamps is more than 24 hours?  will it bomb, or just
roll over to 00.00.01 ?

thanks again,
Rick

--original message--
Richard, you can't directly get a time from subtracting two timestamps
because a time represents a time of day, not a duration.  Try adding the
seconds to a time value of 00.00.00 to get your duration in a Time
field.

Try this:

      time = t'00.00.00' + %seconds(%diff(ts1 : ts2 : *seconds));

or this:

c    ts1          subdur    ts2             secs:*seconds
c    t'00.00.00'  adddur    secs:*seconds   time