title: Oracle SQL to select rows with timestamp not more than 1 week ago?
body: <p>I want to select all rows which have a timestamp of less than a week ago in a column called <code>UPDATE_TIME</code> in a table called <code>generic</code>. From an earlier question I developed this script:</p>
  
  <pre><code>select * from generic where 'UPDATE_TIME' &lt; UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 WEEK))
  </code></pre>
  
  <p>But this is giving me this error:</p>
  
  <pre><code>ORA-00907: missing right parenthesis
  00907. 00000 -  "missing right parenthesis"
  *Cause:    
  *Action:
  Error at Line: 1 Column: 92
  </code></pre>
  
  <p>What am I doing wrong?</p>