BigQuery - how to compare a "date" column (using legacy SQL)?
<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>