title: bigquery converting the string datetime with timezone
body: <p>A table with terabytes of data in bigquery got multiple columns set as string format but actually they contain datetime strings like </p>
  
  <p>2016-10-24 15:00:00</p>
  
  <p>I tried answer from <a href="https://stackoverflow.com/a/36071426/7260022">this link</a> to convert (CAST) the fields into timestamp format as below</p>
  
  <pre><code>SELECT
     CAST( MURDER_DATE AS TIMESTAMP) AS CONVERTED_MURDER_DATE, *
  FROM `death_list`;
  </code></pre>
  
  <p>That works but it converts all strings into timestamps with UTC timezone as below</p>
  
  <pre><code>2007-03-23 15:00:00.000 UTC
  </code></pre>
  
  <p>I need the data in a different timezone. Any clue?    </p>