title: Converting timestamp to a different timezone in BigQuery
body: <p>I've combed through Google's <a href="https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#timestamp-functions" rel="nofollow noreferrer">documentation</a> multiple times, but I can't seem to find a simple function (within a <code>SELECT</code> query) to convert a UTC timestamp to a different timezone, which in my case is Pacific. For most international timezones, I can simply use <code>TIMESTAMP_SUB</code> or <code>TIMESTAMP_ADD</code> to subtract/add offset hours, but the United States use of daylight savings time complicates things (unnecessarily!).</p>
  
  <p>Did I miss something in the documentation? Or is there some other way to easily convert to another timezone?</p>