title: How to compare datetime with only date in SQL Server
body: <pre><code>Select * from [User] U
  where  U.DateCreated = '2014-02-07'     
  </code></pre>
  
  <p>but in the database the user was created on <code>2014-02-07 12:30:47.220</code> and when I only put <code>'2014-02-07'</code></p>
  
  <p>It does not show any data</p>