title: How to select data between two dates from sqlite db in dd-mm-yyyy format?
body: <p>i have date column in my database in <code>dd-mm-yyyy</code> format.</p>
  
  <p>i want to search the data between two dates.</p>
  
  <p>i tried </p>
  
  <pre><code>SELECT * FROM t_data where orderdate between '01-05-2012 00:00:00' and '31-05-2012 23:59:59'
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SELECT * FROM t_data where orderdate &gt;= '05-05-2012' and  orderdate &lt;='31-05-2012'
  </code></pre>
  
  <p>How to resolve this issue?</p>