title: Oracle SQL: How to display a HH24:MI:SS as "Hours: #, Minutes #, Seconds #"?
body: <p>Title says it all, I want </p>
  
  <pre><code>19:33:25 
  </code></pre>
  
  <p>to display as</p>
  
  <pre><code>Hours: 19, Minutes: 33, Seconds: 25
  </code></pre>
  
  <p>This is the query that I used to get 19:33:25, basically a date converted to string.</p>
  
  <pre><code>TO_CHAR(TO_DATE(24 * 60 * 60 * (a.dateEnd - SYSDATE),'sssss'),'hh24:mi:ss')
  </code></pre>
  
  <p>Is something like this possible?</p>
  
  <p>Thanks for any input!</p>