title: bigquery standard sql error, invalid timestamp
body: <p>I'm playing with some tables in bigquery and I receive this error:</p>
  
  <blockquote>
    <p>Cannot return an invalid timestamp value of -62169990264000000 microseconds relative to the Unix epoch.<br>
    The range of valid timestamp values is [0001-01-1 00:00:00, 9999-12-31 23:59:59.999999]</p>
  </blockquote>
  
  <p>Doing the query in legacy sql and sorting ascending, it displays as 0001-11-29 22:15:36 UTC </p>
  
  <p>How does it get transformed into microseconds?</p>
  
  <p>This is the query:</p>
  
  <pre><code>#standardSQL
  SELECT
    birthdate
  FROM
    X
  WHERE
    birthdate IS NOT NULL
  ORDER BY
    birthdate ASC
  </code></pre>