title: Select Today's date using BigQuery
body: <p>I'm using Google Cloud SDK (command-line) via C# and I want to select the information for the Current Date(today).</p>
  <p>The select is working but I'm not able to bring the latest date on the column DATE
  Below is the query I'm using:</p>
  <pre><code>        var table = client.GetTable(&quot;projectId&quot;, &quot;datasetId&quot;, &quot;table&quot;);
  
          var sql = $&quot;&quot; +
              $&quot;SELECT &quot; +
              $&quot;sku, &quot; +
              $&quot;FROM {table} &quot; +
              $&quot;WHERE DATE=CurrentDate('America/Sao_Paulo') &quot; +
              $&quot;LIMIT 10&quot;;
  </code></pre>
  <p>Schema: SKU  - String
  DATE - Timestamp</p>