NexJ Logo

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 and short name values for time zones
NameShort NameDescription
Etc/GMT-12GMT+12:00(GMT-12:00) International Date Line West
Pacific/ApiaWST(GMT-11:00) Midway Island, Samoa
Pacific/HonoluluHST(GMT-10:00) Hawaii
America/AnchorageAKST(GMT-09:00) Alaska
America/Los_AngelesPST(GMT-08:00) Pacific Time (US & Canada); Tijuana
America/DenverMST(GMT-07:00) Mountain Time (US & Canada)
America/TegucigalpaCST(GMT-07:00) Chihuahua, La Paz, Mazatlan
America/PhoenixMST(GMT-07:00) Arizona
America/WinnipegCST(GMT-06:00) Saskatchewan
America/Mexico_CityCST(GMT-06:00) Guadalajara, Mexico City, Monterrey
America/ChicagoCST(GMT-06:00) Central Time (US & Canada)
America/Costa_RicaCST(GMT-06:00) Central America
America/Indiana/IndianapolisEST(GMT-05:00) Indiana (East)
America/New_YorkEST(GMT-05:00) Eastern Time (US & Canada)
America/BogotaCOT(GMT-05:00) Bogota, Lima, Quito
America/SantiagoCLT(GMT-04:00) Santiag
America/CaracasVET(GMT-04:00) Caracas, La Paz
America/AnguillaAST(GMT-04:00) Atlantic Time (Canada)
America/St_JohnsNST(GMT-03:30) Newfoundland
America/ThuleAST(GMT-03:00) Greenland
America/Argentina/Buenos_AiresART(GMT-03:00) Buenos Aires, Georgetown
America/Sao_PauloBRT(GMT-03:00) Brasilia
Atlantic/South_GeorgiaGST(GMT-02:00) Mid-Atlantic
Atlantic/Cape_VerdeCVT(GMT-01:00) Cape Verde Is.
Atlantic/AzoresAZOT(GMT-01:00) Azores
Africa/CasablancaWET(GMT) Casablanca, Monrovia
Europe/DublinGMT(GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London
Etc/UTCUTC(UTC) Coordinated Universal Time
Europe/AmsterdamCET(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna
Europe/BelgradeCET(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague
Europe/BrusselsCET(GMT+01:00) Brussels, Copenhagen, Madrid, Paris
Europe/WarsawCET(GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb
Africa/LagosWAT(GMT+01:00) West Central Africa
Europe/AthensEET(GMT+02:00) Athens, Istanbul, Minsk
Europe/BucharestEET(GMT+02:00) Bucharest
Africa/CairoEET(GMT+02:00) Cairo
Africa/HarareCAT(GMT+02:00) Harare, Pretoria
Europe/HelsinkiEET(GMT+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius
Asia/JerusalemIST(GMT+02:00) Jerusalem
Asia/BaghdadAST(GMT+03:00) Baghdad
Asia/KuwaitAST(GMT+03:00) Kuwait, Riyadh
Europe/MoscowMSK(GMT+03:00) Moscow, St. Petersburg, Volgograd
Africa/NairobiEAT(GMT+03:00) Nairobi
Asia/TehranIRST(GMT+03:30) Tehran
Asia/DubaiGST(GMT+04:00) Abu Dhabi, Muscat
Asia/BakuAZT(GMT+04:00) Baku, Tbilisi, Yerevan
Asia/KabulAFT(GMT+04:30) Kabul
Asia/YekaterinburgYEKT(GMT+05:00) Ekaterinburg
Asia/KarachiPKT(GMT+05:00) Islamabad, Karachi, Tashkent
Asia/CalcuttaIST(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi
Asia/KatmanduNPT(GMT+05:45) Kathmandu
Asia/AlmatyALMT(GMT+06:00) Almaty, Novosibirsk
Asia/DhakaBDT(GMT+06:00) Astana, Dhaka
Asia/ColomboLKT(GMT+06:00) Sri Jayawardenepura
Asia/RangoonMMT(GMT+06:30) Rangoon
Asia/BangkokICT(GMT+07:00) Bangkok, Hanoi, Jakarta
Asia/KrasnoyarskKRAT(GMT+07:00) Krasnoyarsk
Asia/Hong_KongHKT(GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi
Asia/IrkutskIRKT(GMT+08:00) Irkutsk, Ulaan Bataar"
Asia/Kuala_LumpurMYT(GMT+08:00) Kuala Lumpur, Singapore
Australia/PerthWST(GMT+08:00) Perth
Asia/TaipeiCST(GMT+08:00) Taipei
Asia/TokyoJST(GMT+09:00) Osaka, Sapporo, Tokyo
Asia/SeoulKST(GMT+09:00) Seoul
Asia/YakutskYAKT(GMT+09:00) Yakutsk
Australia/AdelaideCST(GMT+09:30) Adelaide
Australia/DarwinCST(GMT+09:30) Darwin
Australia/BrisbaneEST(GMT+10:00) Brisbane
Australia/SydneyEST(GMT+10:00) Canberra, Melbourne, Sydney
Pacific/GuamChST(GMT+10:00) Guam, Port Moresby
Australia/HobartEST(GMT+10:00) Hobart
Asia/VladivostokVLAT(GMT+10:00) Vladivostok
Asia/MagadanMAGT(GMT+11:00) Magadan, Solomon Is., New Caledonia
Pacific/AucklandNZST(GMT+12:00) Auckland, Wellington
Pacific/FijiFJT(GMT+12:00) Fiji, Kamchatka, Marshall Is.
Pacific/TongatapuTOT(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