title: Update records in table based on hours difference between dates
body: <p>I am trying to update records in tables which are more than 24 hours old (1 day). I thought of taking difference on Day instead of hours by using below query :</p>
  
  <pre><code>UPDATE Testing 
  SET STS_CD='02'
  WHERE EXTRACT(DAY FROM SYSTIMESTAMP)- EXTRACT(DAY FROM UPD_DTM)&gt; 1
  </code></pre>
  
  <p>Now, there could be situation where we have to check records which are 12 hours old or 36 hours old. So, I have to take difference based on Hours only now.
  And, I am not getting correct result when trying to get difference on the based of hours. Can you please suggest ?</p>
  
  <pre><code>UPDATE Testing 
  SET STS_CD='02'
  WHERE EXTRACT(HOURS FROM SYSTIMESTAMP)- EXTRACT(HOURS FROM UPD_DTM)&gt; 24
  </code></pre>