Google Big Query Invalid time zone: +0000

Question

Getting the error

Query Failed
Error: Invalid time zone: +0000

Is there a way to ignore time zones or default everything to UCT This is my where condition

WHERE TIMESTAMP(FORMAT_TIMESTAMP("%Y-%m-%d %H:%M:%E6S%z", PARSE_TIMESTAMP("%Y%m%d", date )),"UCT") = TIMESTAMP('2018-03-05 00:00',"UCT")

date column is string in this format 20180307

Answer 1

_{Community wiki answer originally left by the question asker as a comment:}

The fix was removing the timestamp formatting from FORMAT_TIMESTAMP

TIMESTAMP(FORMAT_TIMESTAMP("%Y-%m-%d", PARSE_TIMESTAMP("%Y%m%d", ga.date )))

Answer 2

You're specifying UCT, an invalid time zone as it is a misspelling. The time zone you are looking for is UTC.

Incorrect:

... TIMESTAMP('2018-03-05 00:00',"UCT")

Correct:

... TIMESTAMP('2018-03-05 00:00',"UTC")