title: How do I compare two timestamps as dates in SQL Server
body: <p>I want to run a query to bring back that occurred on or after a date where the input date is a timestamp and the and the table is a timestamp. The problem i have is right now results are getting excluded based on time so some go missing. Refer to below sample for details</p>
  
  <p>Sample SQL</p>
  
  <pre><code>Select *
  from table
  where DateTime &gt;= InputDateTime
  </code></pre>
  
  <p>Sample Table</p>
  
  <pre><code>Row | DateTime
  1   | 2015-01-16 23:12:11
  2   | 2015-01-15 06:12:24
  3   | 2015-01-14 23:12:24
  4   | 2015-01-15 23:12:24
  5   | 2015-01-12 23:12:24
  </code></pre>
  
  <p>Expected result if InputDateTime =  2015-01-15 12:13:24</p>
  
  <pre><code>Row | DateTime
  1   | 2015-01-16 23:12:11
  2   | 2015-01-15 06:12:24
  4   | 2015-01-15 23:12:24
  </code></pre>