title: Query to select data between two dates with the format m/d/yyyy
body: <p>I am facing problem when i'm trying to select records from a table between two dates.</p>
  
  <p>m using the following query</p>
  
  <pre><code>select * from xxx where dates between '10/10/2012' and '10/12/2012'
  </code></pre>
  
  <p>this query works for me but when the dates are in format like 1/1/2013.. it doesn't work..</p>
  
  <p>plz solve my problem ASAP.</p>