title: How to convert the spanner TIMESTAMP to BigQuery TIMESTAMP?
body: <p>I am trying to copy some tables from Spanner to BigQuery.</p>
  
  <p>I dumped Spanner database in csv file and when I try to upload that csv to BigQuery it is throwing error of the timestamp format.</p>
  
  <p><a href="https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-csv#Limitations" rel="nofollow noreferrer">Here</a> they mentioned limitation of BigQuery TIMESTAMP.</p>
  
  <p>How do I convert spanner TIMESTAMP to BigQuery TIMESTAMP?</p>