title: how to convert mysql TIMESTAMPDIFF to oraclesql query
body: <p>TIMESTAMPDIFF(HOUR, pk.consprtydate, rs.consprtydate)</p>
  
  <p>wanted the difference of hours from two dates and extract the hours in oracle sql</p>