March 2013

Calculating Elapsed Time in Oracle

A frequent report request is the difference between a start and end time, expressed as HH:MI:SS. Rather than mess around with all sorts of SUBSTR, TO_CHAR and TO_DATE mishmash, I like to take advantage of Oracle’s powerful date manipulation: Simply turn the difference between the dates into an integer (a fraction of a day), add […]

Read more →