Diff between Timestamp

[Shakthivel V]

Hi. How to get the difference between two timestamp in PL/I??

[NicC]

Are these DB2 timestamps?

[Shakthivel V]

yes.. Its DB2 Timestamp only. but i need to check in my pli program .

[NicC]

I think you can use the DAYS builtin function - convert both, subtract and then another BIF (same section of the manual) to convert the result back to time. Something like

diff = days(ts1) - days(ts2)
ans = ????(diff)

[prino]

I think you can use the DAYS builtin function - convert both, subtract and then another BIF (same section of the manual) to convert the result back to time. Something like

diff = days(ts1) - days(ts2)
ans = ????(diff)

Don't "think you can use", if you had RFTM, you would have known that the DAYS builtin is useless for DB2 timestamps, none of the PL/I builtin functions supports the "YYYYMMDDHHMISS999999" format of DB2 timestamps!

You need extended float (i.e. FLOAT DEC (33), or FLOAT DEC(34) for DFP)) to cater for the full range of self-calculated microseconds, unless you split it in date and time parts, in which case you still have to handle the micro-second part yourself!

[NicC]

Good catch - I only glanced at the manual. One can always drop off the microseconds unless it is so really important but that is the analyst's call.