title: Query datetime in SQL without time
body: <p>I'm trying to write a SQL query which should just pick the count with specific date not time.</p>
  
  <pre><code>select count(*) from xyz where time='2010-01-21'
  </code></pre>
  
  <p>but it is not returning any results.</p>