BigQuery Date Functions Not Found in API Querying
<p>I am getting a ApiError: Function not found: STRFTIME_UTC_USEC error when I try to run the following query using the node.js BQ API:</p>

<pre><code>SELECT STRFTIME_UTC_USEC(created, "%h %d %Y") as user_created from `tablePath`
</code></pre>

<p>According to the BQ docs 
<a href="https://cloud.google.com/bigquery/docs/reference/legacy-sql#datetimefunctions" rel="nofollow noreferrer">https://cloud.google.com/bigquery/docs/reference/legacy-sql#datetimefunctions</a> , the Function STRFTIME_UTC_USEC is available in BQ. and in fact the same query works in the Query builder on the BQ Console Website (just change the table escape characters from `` to []).</p>

<p>The code calling the query looks like: </p>

<pre><code>const BigQuery = require('@google-cloud/bigquery');
const sqlQuery = SELECT STRFTIME_UTC_USEC(created, "%h %d %Y") as user_created from `tablePath`
const options = {
query: sqlQuery,
useLegacySql: false // Use standard SQL syntax for queries.
};
bigquery.query(options)    
.then(function (results) {
  const rows = results[0];
  console.log(rows);
  callback(rows); 
});
</code></pre>

<p>Any solutions out there for formatting timestamps with node.js API for BigQuery? I also get the same error trying to use the YEAR() function in the query string.</p>