title: BigQuery: Unrecognized timezone when importing CSV
body: <p>How can you define the <strong>timezone</strong> of a timestamp when loading into <strong>BigQuery</strong> from a <strong>CSV</strong> file?</p>
  
  <p>none of these seem to work:</p>
  
  <ul>
  <li>2018-07-31 11:55:00 Europe/Rome</li>
  <li>2018-07-31 11:55:00 CET</li>
  </ul>
  
  <p>I get the following error:</p>
  
  <blockquote>
    <p>{Location: "query"; Message: "Unrecognized timezone: Europe/Rome;
    Could not parse '2018-07-31 11:55:00 Europe/Rome' as datetime for
    field ts (position 0) starting at location 0"; Reason: "invalidQuery"}</p>
  </blockquote>
  
  <p>I am running an import from Google Cloud Storage, using this Go code:</p>
  
  <pre><code>gcsRef := bigquery.NewGCSReference(gcsFilename)
  gcsRef.SourceFormat = bigquery.CSV
  gcsRef.FieldDelimiter = "|"
  gcsRef.Schema = bigquery.Schema{
      {Name: "ts", Type: bigquery.TimestampFieldType},
      {Name: "field2", Type: bigquery.StringFieldType},
      {Name: "field3", Type: bigquery.StringFieldType},
  }
  loader := bigqueryClient.Dataset("events").Table("mytable").LoaderFrom(gcsRef)
  loader.WriteDisposition = bigquery.WriteAppend
  
  job, err := loader.Run(ctx)
  if err != nil {
      log.Fatalln("loader.Run", err.Error())
  }
  status, err := job.Wait(ctx)
  if err != nil {
      log.Fatalln("job.Wait", err.Error())
  }
  if status.Err() != nil {
      log.Fatalln("Job completed with error: %v", status.Err(), status.Errors)
  }
  </code></pre>