Select records from a particular date
<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>