There is no to_char function available for intervals. Or at least it does not work as expected SQL> select to_char(interval ‘1234’ second, ‘HH24:MM’) from dual; TO_CHAR(INTERVAL’12 ——————- +00 00:20:34.000000 I just write my own one, with some new format elements For interval day to second, I have DDD number of days, HH number of hours […]