title: formatting timestamp from BigQuery to Google Spreadsheet
body: <p>I'm creating a spreadsheet that hits BigQuery with Apps Script.  Here's part of my query:</p>
  
  <pre><code>SELECT
    id,
    USEC_TO_TIMESTAMP(created) AS created,
    USEC_TO_TIMESTAMP(modified) AS modified,
    USEC_TO_TIMESTAMP(resolved) AS resolved,
    status_id,
  FROM
    [mydata:mydataset.latest]
  WHERE  blah blah blah...
  </code></pre>
  
  <p>When I run this from <a href="http://bigquery.cloud.google.com" rel="nofollow">http://bigquery.cloud.google.com</a>, I get timestamps that look like "2013-08-22 19:19:01 UTC" (this is great).  However, when I run the same query from a spreadsheet, I get dates that don't make sense.  If I remove the function USEC_TO_TIMESTAMP, the dates still don't make sense.  What I mean by "don't make sense", is that if I format the numbers as dates, I get garbage values.  What is the recommended way to query dates from a spreadsheet?</p>
  
  <p>(from a mailing list)</p>