title: SQL, GETDATE in where clause
body: <p>I am trying to use my query as the current day for my SQL query.</p>
  
  <p>What I am trying below returns 0 records:</p>
  
  <pre><code>select * 
  from [TEST].[dbo].LIMIT 
  where endOfDay = GETDATE()
  
  select * 
  from [TEST].[dbo].LIMIT 
  where endOfDay = dateadd(dd, datediff(dd, 0, getdate()), 0)
  
  where endOfDay &gt;= getdate() and endOfDay &lt; getdate() + 1 
  </code></pre>
  
  <p>An example date would be <code>2019-07-09 00:00:00.0</code></p>
  
  <p>Also if there is no given date for today's date can I get a range of dates?</p>
  
  <p>Any help would be appreciated, thanks.</p>