Converting ISO8601 strings with timezone to DATETIME

[marr]

Is it expected that you wouldn’t be able to convert an iso8601 string to a date with timezone?
The format seems to be required, as select date('1980-01-01T00:00:00.000Z', "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'"); returns a datetime, but select date('1980-01-01T00:00:00.000Z'); returns null.
I’m also unsure how I would select a datetime from a 8601 timestamp with timezone…

[lvca]

If no format is specified, then the database formats are used, checking for date and datetime (based on the length of the input). Same thing for the timezone, if not specified, the database timezone is used. You can check your setting on studio -> database.