title: SQLite DateTime comparison
body: <p>I can't seem to get reliable results from the query against a sqlite database using a datetime string as a comparison as so:</p>
  
  <pre><code>select * 
    from table_1 
   where mydate &gt;= '1/1/2009' and mydate &lt;= '5/5/2009'
  </code></pre>
  
  <p>how should I handle datetime comparisons to sqlite?</p>
  
  <p>update:
  field mydate is a DateTime datatype</p>