You can use the FROM_UTC_TIMESTAMP function to convert a UTC timestamp into a timestamp in a specified time zone. The following table provides the supported destination time zones.
Time zone type |
Time zone |
Etc/GMT+12 |
(UTC-12:00) International Date Line West |
Etc/GMT+11 |
(UTC-11:00) Coordinated Universal Time-11 |
Pacific/Honolulu |
(UTC-10:00) Hawaii |
Pacific/Gambier |
(UTC-09:00) Gambier Islands , French Polynesia |
America/Santa_Isabel |
(UTC-08:00) Baja California |
America/Los_Angeles |
(UTC-08:00) Pacific Time (US and Canada) |
America/Phoenix |
(UTC-07:00) Arizona |
America/Denver |
(UTC-07:00) Mountain Time (US and Canada) |
America/Guatemala |
(UTC-06:00) Central America |
America/Chicago |
(UTC-06:00) Central Time (US and Canada) |
America/Regina |
(UTC-06:00) Saskatchewan |
America/Mexico_City |
(UTC-06:00) Guadalajara, Mexico City, Monterrey |
America/Bogota |
(UTC-05:00) Bogota, Lima, Quito |
America/Indiana/Indianapolis |
(UTC-05:00) Indiana (East) |
America/New_York |
(UTC-05:00) Eastern Time (US and Canada) |
America/Halifax |
(UTC-04:00) Atlantic Time (Canada) |
America/Asuncion |
(UTC-04:00) Asuncion |
America/La_Paz |
(UTC-04:00) Georgetown, La Paz, Manaus, San Juan |
America/Cuiaba |
(UTC-04:00) Cuiaba |
America/St_Johns |
(UTC-03:30) Newfoundland |
America/Sao_Paulo |
(UTC-03:00) Brasilia |
America/Godthab |
(UTC-03:00) Greenland |
America/Cayenne |
(UTC-03:00) Cayenne, Fortaleza |
America/Argentina/Buenos_Aires |
(UTC-03:00) Buenos Aires |
America/Montevideo |
(UTC-03:00) Montevideo |
Etc/GMT+2 |
(UTC-02:00) Coordinated Universal Time-2 |
Atlantic/Azores |
(UTC-01:00) Azores |
Africa/Casablanca |
(UTC+00:00) Casablanca |
Atlantic/Reykjavik |
(UTC+00:00) Monrovia, Reykjavik |
Etc/GMT |
(UTC+00:00) Coordinated Universal Time |
Europe/Berlin |
(UTC+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, and Vienna |
Europe/Paris |
(UTC+01:00) Brussels, Copenhagen, Madrid, Paris |
Africa/Lagos |
(UTC+01:00) West Central Africa |
Europe/Budapest |
(UTC+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague |
Europe/Warsaw |
(UTC+01:00) Sarajevo, Skopje, Warsaw, Zagreb |
Europe/Istanbul |
(UTC+02:00) Athens, Bucharest, and Istanbul |
Africa/Cairo |
(UTC+02:00) Cairo |
Asia/Damascus |
(UTC+02:00) Damascus |
Asia/Amman |
(UTC+02:00) Amman |
Africa/Johannesburg |
(UTC+02:00) Harare, Pretoria |
Asia/Jerusalem |
(UTC+02:00) Jerusalem |
Asia/Beirut |
(UTC+02:00) Beirut |
Asia/Baghdad |
(UTC+03:00) Baghdad |
Europe/Minsk |
(UTC+03:00) Minsk |
Asia/Riyadh |
(UTC+03:00) Riyadh |
Africa/Nairobi |
(UTC+03:00) Nairobi |
Asia/Tehran |
(UTC+03:30) Tehran |
Europe/Moscow |
(UTC+04:00) Moscow, St. Petersburg, and Volgograd |
Asia/Tbilisi |
(UTC+04:00) Tbilisi |
Asia/Yerevan |
(UTC+04:00) Yerevan |
Asia/Dubai |
(UTC+04:00) Abu Dhabi, Muscat |
Asia/Baku |
(UTC+04:00) Baku |
Indian/Mauritius |
(UTC+04:00) Port Louis |
Asia/Kabul |
(UTC+04:30) Kabul |
Asia/Karachi |
(UTC+05:00) Islamabad and Karachi |
Asia/Colombo |
(UTC+05:30) Srigaya Vordenpla |
Asia/Kolkata |
(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi |
Asia/Almaty |
(UTC+06:00) Astana |
Asia/Dhaka |
(UTC+06:00) Dhaka |
Asia/Bangkok |
(UTC+07:00) Bangkok, Hanoi, and Jakarta |
Asia/Novosibirsk |
(UTC+07:00) Novosibirsk |
Asia/Shanghai |
(UTC+08:00) Beijing, Chongqing, Hong Kong, and Urumqi |
Australia/Perth |
(UTC+08:00) Perth |
Asia/Taipei |
(UTC +08:00) China (Taipei) |
Asia/Seoul |
(UTC+09:00) Seoul |
Asia/Tokyo |
(UTC+09:00) Osaka, Sapporo, Tokyo |
Australia/Darwin |
(UTC+09:30) Darwin |
Australia/Adelaide |
(UTC+09:30) Adelaide |
Australia/Brisbane |
(UTC+10:00) Brisbane |
Pacific/Port_Moresby |
(UTC+10:00) Guam, Port Moresby |
Australia/Sydney |
(UTC+10:00) Canberra, Melbourne, Sydney |
Pacific/Guadalcanal |
(UTC+11:00) Solomon Islands, New Caledonia |
Etc/GMT-12 |
(UTC+12:00) Coordinated Universal Time+12 |
Pacific/Fiji |
(UTC+12:00) Fiji and Marshall Islands |
Pacific/Auckland |
(UTC+12:00) Auckland, Wellington |
Pacific/Tongatapu |
(UTC+13:00) Nuku'alofa |