title: Arithmetic overflow error converting expression in to data type datetime
body: <p>Hoping someone can help. I've looked on the internet for a solution but none seem to resolve it. </p>
  
  <p>I want to query a large table and only get the results back where a column equals today's date. </p>
  
  <p>Here's the query:</p>
  
  <pre><code>select [Table1].[Field1]
  from [Table1]
  where [Table1].[Field1] = GetDate()
  </code></pre>
  
  <p>The date format is as follows:</p>
  
  <pre><code> 20020630
  </code></pre>
  
  <p>I'm a beginner in SQL so any help would be really appreciated because I am growing fond of it.</p>
  
  <p>Thank you!!! :) </p>