title: SQL SELECT WHERE with date and time
body: <p>I have a <code>SELECT</code> query where I want to find all rows whose DATE and TIME are between <code>2011-12-11 23:00:00</code> and  <code>2011-12-12 23:00:00</code> I try to do it with WHERE but row is empty</p>
  
  <pre><code>WHERE (date &gt;= '2011-12-11' AND time &gt; '23:00:00' )
  AND   (date &lt;  '2011-12-12' AND time &lt; '23:00:00' )
  </code></pre>
  
  <p>Pls, any good suggestion how to change this?</p>