BigQuery new data type DATE -

i see new data typedate being introduced in bigquery web ui not documented in https://cloud.google.com/bigquery/data-types. date such not new have 1 major question. unlike timestamp date ignore timezone information after being stored.

quoted text timestamp documentation:

you can supply timezone offset in date , time strings, bigquery doesn't preserve offset after converting value internal format. if need preserve original timezone data, store timezone offset in separate column.

also whats expected input format. have tried known timestamp strings not seem work.

i see new data typedate being introduced in bigquery web ui not documented

date type introduced standard sql - see date type details

also whats expected input format

canonical format

'yyyy-[m]m-[d]d' yyyy: four-digit year [m]m: 1 or 2 digit month [d]d: 1 or 2 digit day  

note: date type represents logical calendar date, independent of time zone.