title: SQL SELECT statement error with datetime
body: <p>Something is wrong with statements with datetime field:</p>
  
  <p>MyDB:</p>
  
  <pre><code>id  name   datetime
  1   test1  2011-04-28 19:37:44
  2   test2  2011-04-28 21:27:04
  </code></pre>
  
  <p>When I run the following statement</p>
  
  <pre><code>SELECT * 
  FROM myTable 
  WHERE ('datetime' &gt; '2011-04-28 21:00:00')
  </code></pre>
  
  <p>I get all - test1 and test2</p>
  
  <p>When I run this statement</p>
  
  <pre><code>SELECT * 
  FROM myTable 
  WHERE ('datetime' = '2011-04-28 21:27:04')
  </code></pre>
  
  <p>I get nothing</p>
  
  <p>When I run the following statement</p>
  
  <pre><code>SELECT * 
  FROM myTable 
  WHERE ('datetime' &gt; '2011-04-28 21:00:00')
      AND ('datetime' &lt; '2011-04-29 21:00:00')
  </code></pre>
  
  <p>I get nothing</p>
  
  <p>Why?</p>