title: Select rows 1 week before of a timestamp
body: <p>There is an INT field which I store timestamps in table. </p>
  
  <p>I am trying to select rows 1 week before this timestamp</p>
  
  <pre><code>WHERE last_loc_date &gt; DATE(NOW()) - INTERVAL 1 WEEK
  </code></pre>
  
  <p>Doesn't work. Any idea? </p>