title: Converting date column in sqlite, can't query against it
body: <p>I'm importing .csv files into an SQLite database. I am attempting to query against one of the tables. I think it is getting hung up on dates, which are in <em>MM/DD/YYYY</em> format. Not all months and days are two digits either.</p>
  
  <p>I've tried this query:</p>
  
  <pre><code>SELECT * FROM &lt;table&gt; 
  WHERE 'account' = &lt;account_number&gt; 
  and 'date' between '1900-01-01' and '2013-03-03'
  </code></pre>
  
  <p>I've also tried:</p>
  
  <pre><code>select * from &lt;table&gt; 
  where 'account' = &lt;account_number&gt; 
  and 'date' &gt; '1901-01-01' and 'date' &lt; '2013-03-03'
  </code></pre>
  
  <p>It doesn't work.</p>