For more information about the GoogleSQL type system, see the GoogleSQL data types reference. For more information about data types in BigQuery, see the BigQuery data types reference. TIMESTAMP differences GoogleSQL has a stricter range of valid TIMESTAMP values than legacy SQL does. In GoogleSQL, valid TIMESTAMP values are in the range of 0001-01-01 00:00:00.000000 to 9999-12-31 23:59:59.999999.
![Migrating to GoogleSQL | BigQuery | Google Cloud](https://cdn-ak-scissors.b.st-hatena.com/image/square/0e132c7916d37a3584f9bf1740f19a7c8aaf839e/height=288;version=1;width=512/https%3A%2F%2Fcloud.google.com%2F_static%2Fcloud%2Fimages%2Fsocial-icon-google-cloud-1200-630.png)