Google BigQuery Date Data Type?

Question

Is there a date or datetime data type in Google BigQuery? I looked at the online documentation, but the data types mentioned didn't include any date types

Answer 1

2013 update:

BigQuery now has a Timestamp type.

Look at: BigQuery datatypes

2018: TIMESTAMP, TIME, DATE, DATETIME

Answer 2

2016 update:

BigQuery now also has real DATE type (in addition to TIMESTAMP type) in standard SQL:

https://cloud.google.com/bigquery/sql-reference/data-types#date-type https://cloud.google.com/bigquery/sql-reference/functions-and-operators#date