Hi folks!
I'm trying to determine elapsed time using the difference between two timestamps. This is the current expression I am using:
(TO_TIMESTAMP(CAST((A.ENDDTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF') - TO_TIMESTAMP(CAST((A.BEGINDTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF')) * 86400
It works most of the time, but does fail on occasion, especially if the difference is too large.
Was curious to know if anyone has anything better that works more reliably. Google has not been my friend, and AI has been equally unhelpful, so I figured I would consult RI (real intelligence).
Thanks in advance!
------------------------------
Mark Russom B.Sc. FLMI ACS
Business Systems Lead
McMaster University
------------------------------
Message from the HEUG Marketplace:------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the
HEUG Marketplace.
------------------------------