title: How do I convert gps time to date in BigQuery
body: <p>Currently I am using</p>
  
  <pre><code>SELECT TIMESTAMP_SECONDS(CAST(my_time_unix_ns/1000 AS int64)) AS my_date,...
  
  </code></pre>
  
  <p>But some of the columns store time in gps ns. How do I convert them into date?</p>