Time zones
Time zones are defined string values that represent a standard international time zone. They are used in date and time functions to adjust a date value to the specified time zone.
In field control formulas, date values are timestamps that represent a specific date and time. When a date value is created, the time component is stored with a specific time zone offset. Some date and time functions allow you to adjust the time zone that you want the date to be displayed in when it is returned by the function. To do this, you provide the function with a time zone argument, which shifts the time component of the date value according to the time zone's offset.
You can use the following time zones names and short names in date and time functions that take a time zone argument:
Name | Short Name | Description |
---|---|---|
Etc/GMT-12 | GMT+12:00 | (GMT-12:00) International Date Line West |
Pacific/Apia | WST | (GMT-11:00) Midway Island, Samoa |
Pacific/Honolulu | HST | (GMT-10:00) Hawaii |
America/Anchorage | AKST | (GMT-09:00) Alaska |
America/Los_Angeles | PST | (GMT-08:00) Pacific Time (US & Canada); Tijuana |
America/Denver | MST | (GMT-07:00) Mountain Time (US & Canada) |
America/Tegucigalpa | CST | (GMT-07:00) Chihuahua, La Paz, Mazatlan |
America/Phoenix | MST | (GMT-07:00) Arizona |
America/Winnipeg | CST | (GMT-06:00) Saskatchewan |
America/Mexico_City | CST | (GMT-06:00) Guadalajara, Mexico City, Monterrey |
America/Chicago | CST | (GMT-06:00) Central Time (US & Canada) |
America/Costa_Rica | CST | (GMT-06:00) Central America |
America/Indiana/Indianapolis | EST | (GMT-05:00) Indiana (East) |
America/New_York | EST | (GMT-05:00) Eastern Time (US & Canada) |
America/Bogota | COT | (GMT-05:00) Bogota, Lima, Quito |
America/Santiago | CLT | (GMT-04:00) Santiag |
America/Caracas | VET | (GMT-04:00) Caracas, La Paz |
America/Anguilla | AST | (GMT-04:00) Atlantic Time (Canada) |
America/St_Johns | NST | (GMT-03:30) Newfoundland |
America/Thule | AST | (GMT-03:00) Greenland |
America/Argentina/Buenos_Aires | ART | (GMT-03:00) Buenos Aires, Georgetown |
America/Sao_Paulo | BRT | (GMT-03:00) Brasilia |
Atlantic/South_Georgia | GST | (GMT-02:00) Mid-Atlantic |
Atlantic/Cape_Verde | CVT | (GMT-01:00) Cape Verde Is. |
Atlantic/Azores | AZOT | (GMT-01:00) Azores |
Africa/Casablanca | WET | (GMT) Casablanca, Monrovia |
Europe/Dublin | GMT | (GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London |
Etc/UTC | UTC | (UTC) Coordinated Universal Time |
Europe/Amsterdam | CET | (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna |
Europe/Belgrade | CET | (GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague |
Europe/Brussels | CET | (GMT+01:00) Brussels, Copenhagen, Madrid, Paris |
Europe/Warsaw | CET | (GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb |
Africa/Lagos | WAT | (GMT+01:00) West Central Africa |
Europe/Athens | EET | (GMT+02:00) Athens, Istanbul, Minsk |
Europe/Bucharest | EET | (GMT+02:00) Bucharest |
Africa/Cairo | EET | (GMT+02:00) Cairo |
Africa/Harare | CAT | (GMT+02:00) Harare, Pretoria |
Europe/Helsinki | EET | (GMT+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius |
Asia/Jerusalem | IST | (GMT+02:00) Jerusalem |
Asia/Baghdad | AST | (GMT+03:00) Baghdad |
Asia/Kuwait | AST | (GMT+03:00) Kuwait, Riyadh |
Europe/Moscow | MSK | (GMT+03:00) Moscow, St. Petersburg, Volgograd |
Africa/Nairobi | EAT | (GMT+03:00) Nairobi |
Asia/Tehran | IRST | (GMT+03:30) Tehran |
Asia/Dubai | GST | (GMT+04:00) Abu Dhabi, Muscat |
Asia/Baku | AZT | (GMT+04:00) Baku, Tbilisi, Yerevan |
Asia/Kabul | AFT | (GMT+04:30) Kabul |
Asia/Yekaterinburg | YEKT | (GMT+05:00) Ekaterinburg |
Asia/Karachi | PKT | (GMT+05:00) Islamabad, Karachi, Tashkent |
Asia/Calcutta | IST | (GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi |
Asia/Katmandu | NPT | (GMT+05:45) Kathmandu |
Asia/Almaty | ALMT | (GMT+06:00) Almaty, Novosibirsk |
Asia/Dhaka | BDT | (GMT+06:00) Astana, Dhaka |
Asia/Colombo | LKT | (GMT+06:00) Sri Jayawardenepura |
Asia/Rangoon | MMT | (GMT+06:30) Rangoon |
Asia/Bangkok | ICT | (GMT+07:00) Bangkok, Hanoi, Jakarta |
Asia/Krasnoyarsk | KRAT | (GMT+07:00) Krasnoyarsk |
Asia/Hong_Kong | HKT | (GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi |
Asia/Irkutsk | IRKT | (GMT+08:00) Irkutsk, Ulaan Bataar" |
Asia/Kuala_Lumpur | MYT | (GMT+08:00) Kuala Lumpur, Singapore |
Australia/Perth | WST | (GMT+08:00) Perth |
Asia/Taipei | CST | (GMT+08:00) Taipei |
Asia/Tokyo | JST | (GMT+09:00) Osaka, Sapporo, Tokyo |
Asia/Seoul | KST | (GMT+09:00) Seoul |
Asia/Yakutsk | YAKT | (GMT+09:00) Yakutsk |
Australia/Adelaide | CST | (GMT+09:30) Adelaide |
Australia/Darwin | CST | (GMT+09:30) Darwin |
Australia/Brisbane | EST | (GMT+10:00) Brisbane |
Australia/Sydney | EST | (GMT+10:00) Canberra, Melbourne, Sydney |
Pacific/Guam | ChST | (GMT+10:00) Guam, Port Moresby |
Australia/Hobart | EST | (GMT+10:00) Hobart |
Asia/Vladivostok | VLAT | (GMT+10:00) Vladivostok |
Asia/Magadan | MAGT | (GMT+11:00) Magadan, Solomon Is., New Caledonia |
Pacific/Auckland | NZST | (GMT+12:00) Auckland, Wellington |
Pacific/Fiji | FJT | (GMT+12:00) Fiji, Kamchatka, Marshall Is. |
Pacific/Tongatapu | TOT | (GMT+13:00) Nuku'alofa |
Asia/Yerevan | +04:00 Armenia Time-Asia/Yerevan | |
Asia/Beirut | +02:00 Eastern European Time-Asia/Beirut | |
America/Montevideo | -03:00 Uruguay Time-America/Montevideo | |
Asia/Novosibirsk | +06:00 Novosibirsk Time-Asia/Novosibirsk | |
America/Chihuahua | -07:00 Mountain Standard Time-America/Chihuahua | |
America/Campo_Grande | -04:00 Amazon Time-America/Campo_Grande | |
America/Araguaina | -03:00 Brasilia Time-America/Araguaina | |
America/Ensenada | -08:00 Pacific Standard Time-America/Ensenada | |
Europe/Kaliningrad | +02:00 Eastern European Time-Europe/Kaliningrad | |
Etc/GMT+12 | -12:00 GMT-12:00-Etc/GMT+12 | |
Etc/GMT-11 | +11:00 GMT+11:00-Etc/GMT-11 |