title: SQLite database - select the data between two dates?
body: <p>I want to select my data by date - from a date until another date, so I have this query,</p>
  <pre><code>SELECT * FROM mytalbe WHERE date BETWEEN '2014-10-09' AND '2014-10-10'
  </code></pre>
  <p>But this query only return the data in <code>'2014-10-09'</code>, excluding the data in <code>'2014-10-10'</code>, unless I change the query to this below,</p>
  <pre><code>SELECT * FROM mytalbe WHERE date BETWEEN '2014-10-09' AND '2014-10-11'
  </code></pre>
  <p>This is not an ideal solution. How can I select the data including the data in <code>'2014-10-10'</code>?</p>
  <p><strong>NOTE:</strong></p>
  <p>I think my problem is different from other duplicate questions becos,</p>
  <ol>
  <li>My date type is <code>TEXT</code>.</li>
  <li>I need to select the date's data without its time.</li>
  <li>It is an SQLite database.</li>
  </ol>
  <p>My sample data:</p>
  <pre class="lang-none prettyprint-override"><code>    sid     nid timestamp   date    
  1   20748   5   1412881193  2014-10-09 14:59:53 
  2   20749   5   1412881300  2014-10-09 15:01:40 
  3   20750   5   1412881360  2014-10-09 15:02:40
  </code></pre>