title: Return records from a specific date
body: <p>In my table I have a column <code>date</code> which is <code>DATETIME</code> type where I save my data like <code>2015-10-22</code>. How can I select those rows which their date is older than a specific date, eg <code>2015-10-22</code>. I tried </p>
  
  <p><code>SELECT * FROM MYTABLE where date &gt; '2015-10-09';</code> </p>
  
  <p>but it doesn't return anything..  my DB is built with sqlite.</p>