title: Sqlite date between
body: <p>can you please help me why this code does not work?
  I dont understand why the result include "2017".</p>
  
  <p>SQLLITE</p>
  
  <p><strong>QUERY</strong></p>
  
  <pre><code>SELECT issue_date as count FROM tablename where issue_date &gt;= "08/08/2016" and issue_date &lt; "09/01/2016"
  </code></pre>
  
  <p><strong>Result</strong></p>
  
  <p>"08/08/2017"</p>
  
  <p>"08/11/2017"</p>
  
  <p>"08/18/2017"</p>
  
  <p>"08/18/2017"</p>
  
  <p>"08/22/2017"</p>
  
  <p>"08/22/2017"</p>
  
  <p>"08/28/2017"</p>
  
  <p>"08/31/2017"</p>
  
  <p><strong>Create query</strong></p>
  
  <p>CREATE TABLE tablename (
      issue_date datetime text not null
  }</p>
  
  <p><strong>Insert query</strong></p>
  
  <p>INSERT INTO tablename (issue_date) values ("08/31/2017");</p>