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!