Difference between two times format in hours
<p>I have two dates in database in unix time. I want the difference between them and show that in hours. </p>

<p><strong>For example</strong><br>
Date1: 05/07/2016 14:40:00 PM  <strong>(1467733205)</strong><br>
Date2: 05/07/2016 15:40:05 PM  <strong>(1467729600)</strong></p>

<p><strong>Difference:</strong>
Date2 - Date1 = <strong>3605 s</strong></p>

<p>That result I want to show him in hours. -> <strong>1 hour and 5 seconds</strong></p>

<pre><code>    SELECT TO_CHAR(to_date('01/01/1970', 'dd/mm/yyyy') + (((HOUR_DEPARTURE - DATE_LOADING )/ 60 / 60 / 24)), 'dd "days and" HH:MI:SS')
  FROM dual
</code></pre>

<p>I tried like this but it shous 01 days and 01:00:05 . There is not one day difference.</p>