title: Converting INTERVAL DAY TO SECOND
body: <p>I want to get more readable value using interval data type.</p>
  
  <pre><code>select cast(last_run_duration as INTERVAL DAY TO SECOND(0))
  from dba_scheduler_jobs
  order by 1 desc;
  </code></pre>
  
  <p>Query result like this;</p>
  
  <pre><code>+00 00:00:04.630530
  +00 00:00:01.352359
  +00 00:00:00.737282
  +00 00:00:00.594381
  +00 00:00:00.432710
  </code></pre>
  
  <p>What i want is this. Only getting Hour:minute:second ;</p>
  
  <pre><code> 00:00:04
   00:00:01
   00:00:00
   00:00:00
   00:00:00
  </code></pre>
  
  <p>last_run_duration column's datatype is  <code>INTERVAL DAY(9) TO SECOND(6)</code></p>