title: How do I convert a timestamp to hours?
body: <p>I am doing the following query in Oracle:</p>
  <p>Field &quot;NO&quot; is a number, and field &quot;DATETIME&quot; is a timestamp.</p>
  <pre><code>select
      ARC.NO,
      MAX(ARC.DATETIME) - MIN(ARC.DATETIME) AS HORAS_TRABAJADAS
  FROM archivo ARC
  GROUP BY ARC.NO;
  </code></pre>
  <p>The result is:</p>
  <pre><code>NO 256  
  DATETIME 1 8:8:41.0 
  </code></pre>
  <p>I see that the &quot;1&quot; is shown in the left side and then some time.</p>
  <p>I want to know if it is possible to show 16:17:22 (which is 8.8:41:0 X 2), because it is supposed to be 16:17:22.</p>