title: Oracle SQL Hours Difference between dates in HH:MM:SS
body: <p>I already have a string to calculate the difference in hours between 2 dates which I'd got from stack:</p>
  
  <pre><code>24 *  (to_date(to_char(stp.created_date,'YYYY-MM-DD hh24:mi:ss'),'YYYY-MM-DD hh24:mi:ss') -
  (to_date(to_char(adhh.created_date,'YYYY-MM-DD hh24:mi:ss'),'YYYY-MM-DD hh24:mi:ss'))) diff_hours
  </code></pre>
  
  <p>But I want to see this as HH:MM:SS</p>
  
  <p>Here's 2 dates/times as example:
  <strong>STP date 26-Feb-18 12.59.21
  ADHH date 26-Feb-18 12.59.32</strong></p>
  
  <p>So I want it to say difference is 00:00:11  (11 seconds)</p>
  
  <p>at the moment I get the result as -0.003 hours</p>
  
  <p>Thanks in advance as always</p>