title: How to compare two DateTime columns Oracle
body: <p>I have a column where I insert a date when the event happens (storage locally), and the date when the event is send to my system.</p>
  
  <p>The difference between the event date and the send date can not be more than 168h (7 days). </p>
  
  <p>I would like to select all rows where the event data + 168h is lower than the send data.</p>
  
  <p>Something like:</p>
  
  <pre><code>SELECT * FROM SALE
  WHERE (DAT_SALE + 168HOUR) &lt; DAT_SEND_SALE;
  </code></pre>