title: Oracle SQL Where Clause against a date column
body: <p>I have a DATE column with a date in it but I need to query it to find records less than 30 days old. </p>
  
  <pre><code>START_DATE
  ----------
  01-AUG-2010
  09-AUG-2010
  22-AUG-2010
  09-SEP-2010
  </code></pre>
  
  <p>Query:</p>
  
  <pre><code>SELECT START_DATE
   WHERE START_DATE &lt; 30;
  </code></pre>
  
  <p>I know it is simple Query in ORACLE SQL but i am doing something wrong.</p>