How to get the difference between datetimes in days, hours, minutes, and/or seconds in Oracle Database
Blog: Oracle BPM
Learn how to convert the difference between dates or timestamps into any units you want. Use these functions to get durations in days to seconds, total hours, months or years to seconds.