title: Select records from a particular date
body: <p>In my table I store the data like <code>2015-11-24 14:53</code>.</p>
  
  <p>When I try to select the records from the date <code>2015-11-24</code></p>
  
  <pre><code>SELECT * FROM TRANSACTIONS where id='22' 
  and date &gt;= date('2015-11-24 00:00')  
  and date &lt;= date('2015-11-24 23:59') 
  </code></pre>
  
  <p>I don't get anything.. (there are records with that date)</p>