title: How to check date time column value equals to current date in sql where clause
body: <p>I have a date time column in sql DB - named <code>check_time</code>. I want to write a select query where this <code>check_time</code> should be equals to today's date (no need to consider what time is. Only need to check current date).
  For example <code>check_time</code> in table is inserted as <code>03/08/2017 12:00:00.000 AM</code>.
  I have written like below</p>
  
  <pre><code>SELECT * FROM time_details  
  WHERE check_time = DATEADD(day, DATEDIFF(day,0,GETDATE()),0)
  </code></pre>
  
  <p>But it returns nothing.</p>