title: BigQuery converting to a different timezone
body: <p>I am storing data in unixtimestamp on google big query.  However, when the user will ask for a report, she will need the filtering and grouping of data by her local timezone.</p>
  
  <p>The data is stored in GMT.  The user may wish to see the data in EST.  The report may ask the data to be grouped by date.  </p>
  
  <p>I don't see the timezone conversion function <a href="https://developers.google.com/bigquery/docs/query-reference#timestampfunctions">here</a>: </p>
  
  <p>Does anyone know how I can do this in bigquery?  i.e. how do i group by after converting the timestamp to a different timezone?</p>