title: Select query with date condition
body: <p>I would like to retrieve the records in certain dates after <code>d/mm/yyyy</code>, or after <code>d/mm/yyyy</code> and before <code>d/mm/yyyy</code>, how can I do it ?</p>
  
  <pre><code>SELECT date
  FROM table
  WHERE date &gt; 1/09/2008;
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SELECT date
  FROM table
  WHERE date &gt; 1/09/2008;
  AND date &lt; 1/09/2010
  </code></pre>
  
  <p>It doesn't work.</p>