Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Timezone in BigQuery

There are lots of IDs with different timestamp and time zone information like America/New_York or Asia/Shanghai, and now I want to convert them all to UTC+0. I know function date_time(timestamp, "America/New_York")  , but I cant convert them based on the filed information because it is typed-in information with quotations

Solved Solved
0 3 232
1 ACCEPTED SOLUTION

Please show at least 3 example rows of your data with the relevant columns.

View solution in original post

3 REPLIES 3