title: BigQuery - how to compare a "date" column (using legacy SQL)?
body: <p>I have a BigQuery table with a column <code>Date</code> which is a <code>date</code> type. I am trying to run this query:</p>
  
  <pre><code>SELECT * FROM dataset.table_name WHERE Date = "2016-07-11"
  </code></pre>
  
  <p>This throws the error:</p>
  
  <pre><code>Argument type mismatch in function EQUAL: 'Date' is type int32, '2016-07-11' is type string
  </code></pre>
  
  <p>I have also tried this query:</p>
  
  <pre><code>SELECT * FROM dataset.table_name WHERE Date = TIMESTAMP("2016-07-11")
  </code></pre>
  
  <p>but this returns 0 results, although my table contains at least one record with this value (<code>2016-07-11</code>) in the <code>Date</code> column.</p>
  
  <p>So, how can I compare a <code>date</code> field in BigQuery?</p>