title: Oracle display more than 24 hours
body: <p>I have a table with two <code>DATE</code> columns <code>END_TIME</code> and <code>START_TIME</code>. On this table I run the following query:</p>
  
  <pre><code>SELECT y.ID,
         TO_CHAR(  TO_DATE('00:00:00', 'HH24:MI:SS') + (y.END_TIME - y.START_TIME) 
                 , 'HH24:MI:SS') AS RUNTIME,
         y.END_TIME - y.START_TIME AS RUNTIME2,
         TO_CHAR(y.START_TIME, 'DD-MON-YYYY HH24:MI:SS') AS START_TIME,
         TO_CHAR(y.END_TIME, 'DD-MON-YYYY HH24:MI:SS') AS END_TIME
  FROM mytable y;
  </code></pre>
  
  <p>I get these two rows as a result:</p>
  
  <pre><code>ID | RUNTIME | RUNTIME2                                   | START_TIME          | END_TIME
  ------------------------------------------------------------------------------------------------------
   1 | 04:26:17| 0.1849189814814814814814814814814814814815 | 30-JAN-2015 19:45:48| 31-JAN-2015 00:12:05
   2 | 03:28:18| 1.14465277777777777777777777777777777778   | 06-FEB-2015 20:47:22| 08-FEB-2015 00:15:40
  </code></pre>
  
  <p>As you can see, <code>ID 2</code> had a runtime larger than 24 hours. How can I change my query so that <code>RUNTIME</code> for <code>ID 2</code> will display <code>27:28:18</code> instead?</p>