ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 28-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
I am trying to get the time difference between 2 dates and format them in HH:MI:SS. I am using this formula
to_char(to_date('00:00:00','HH24:MI:SS') + (DECISION_DT - INITIATION_DT), 'HH24:MI:SS') which works fine until the difference is more than 24 hours. For example if the INITITIATION_DT is 08-FEB-15 08:00:00 and the DECISION_DT is 10-FEB-15 10:05:10 I would want the time difference to be 50:05:10 or 50 hours 5 minutes and 10 seconds. Any help is greatly appreciated!