title: Select condition on date for datetime field
body: <p>I want to impose date condition on a date time field in SQL Server.</p>
  
  <p>The <code>datetime</code> field is like this <code>2011-01-19 17:57:18.350</code> and when I execute below query it yields no results.</p>
  
  <pre><code>select top 1000 * 
  from [dbo].[RouteState] 
  where convert (date, logtime, 101) = '12-01-2015'
  </code></pre>
  
  <p>Can someone help me what's going wrong here?</p>