title: SQL ORDER BY date problem
body: <p>Can you please help me in solving this problem. I am trying to order the results of an SQL query by date, but I'm not getting the results I need.</p>
  
  <p>The query I'm using is:</p>
  
  <pre><code>SELECT date FROM tbemp ORDER BY date ASC
  </code></pre>
  
  <p>Results are:</p>
  
  <pre><code>01/02/2009
  03/01/2009
  04/06/2009
  05/03/2009
  06/12/2008
  07/02/2009
  </code></pre>
  
  <p>Results should be:</p>
  
  <pre><code>06/12/2008
  03/01/2009
  01/02/2009
  07/02/2009
  </code></pre>
  
  <p>I need to select the date in the format above. </p>
  
  <p>Your help is much appreciated.</p>