title: Datetime BETWEEN statement not working in SQL Server
body: <p>I have the following query,</p>
  
  <pre><code>SELECT * FROM LOGS 
  WHERE CHECK_IN BETWEEN CONVERT(datetime,'2013-10-17') AND CONVERT(datetime,'2013-10-18')
  </code></pre>
  
  <p>this query not returning any result, but the following query return the result,</p>
  
  <pre><code>SELECT * FROM LOGS WHERE CHECK_IN &gt;= CONVERT(datetime,'2013-10-17')
  </code></pre>
  
  <p>why the first query not returning any result? If I did any mistake pls correct me.</p>