Geek asks and answers

BigQuery Google Date Data Type?

Does Google BigQuery have a date or date and time data type? I looked through the online documentation, but the data types mentioned did not include date types

+5
source share
3 answers

Edited to add: there is a time type of date, see Fh answer for more information.

There is no date data type, but if you use date dates in ISO format (YYYY-MM-DD HH: MM: SS [.uuuuuu]) or timestamps (convertible to microseconds since 1970), there are a number that you can use. See this page for more information .

0
source

2013 update:

BigQuery now has a Timestamp type.

BigQuery

+6

2016 :

BigQuery now also has a real DATE type (in addition to the 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

+1
source

More articles:


All Articles