title: Mysql DateTime compare
body: <p>Hi I have a table of the following 2 records:</p>
  
  <pre><code>descript | start                | end
  test 1   | 2011-07-18 14:30:00  | 2011-07-18 17:00:00
  test 2   | 2011-07-18 00:00:00  | 2011-07-19 00:00:00
  </code></pre>
  
  <p>When I tried to do a select, I can't seems to retrieve the 2nd result (test 2) which seems like clearly it is dated 19th of July. </p>
  
  <pre><code>SELECT * FROM event WHERE start &gt;= "2011-07-18 00:00:00" AND end &lt;= "2011-07-18 23:59:59";
  </code></pre>
  
  <p>Would appreciate any advise.</p>