title: Sqlite convert string to date
body: <p>I have date stored as string in an sqlite database like "28/11/2010".
  I want to convert the string to date.  </p>
  
  <p>Specifically I have to convert lots of string dates between two dates.</p>
  
  <p>In postgresql, I use <code>to_date('30/11/2010','dd/MM/yyyy')</code>, how can I do the same thing with sqlite?</p>
  
  <p>Something like this:</p>
  
  <pre><code>SELECT * FROM table
      WHERE   to_date(column,'dd/MM/yyyy')
      BETWEEN to_date('01/11/2010','dd/MM/yyyy')
      AND     to_date('30/11/2010','dd/MM/yyyy')
  </code></pre>