# Use date and time functions in formula expressions
<a name="expression-date-and-time-functions"></a>

In [transforms](transforms.md) and [metrics](metrics.md), you can use the date and time functions in the following ways:
+ Retrieve the current timestamp of a data point in UTC or in the local time zone.
+ Construct timestamps with arguments, such as `year`, `month`, and `day_of_month`.
+ Extract a time period such as a year or month with the `unix_time` argument.


| Function | Description | 
| --- | --- | 
| `now()` | Returns the current date and time, in seconds, in the Unix epoch format. | 
| `timestamp()` |  +  In transforms, the function returns the timestamp, in seconds, of the input message in the Unix epoch format. <br />In transforms only, you can do one of the following:   Provide a variable as an argument to the function. The `timestamp({{variable-name}})` function returns the timestamp, in seconds, of the latest `GOOD` quality value for the specified variable in the Unix epoch format. <br />For example, if your asset has a transform property named `Temperature_F` that uses the `9/5 * Temperature_C` formula to convert each temperature data point from Celsius to Fahrenheit, you can use the `timestamp(Temperature_F)` function to get the timestamp of the latest `GOOD` quality value for the `Temperature_F` property.   Use the `pretrigger()` function as an argument to the function. The `timestamp(pretrigger({{variable-name}}))` function returns the timestamp, in seconds, of the `GOOD` quality value for the specified variable prior to the property update that initiated the current transform calculation in the Unix epoch format. For more information, see [Use temporal functions in transforms](expression-temporal-functions.md#temporal-functions-in-transforms).   <br />+  In metrics, the function returns the timestamp retrieved at the end of the current window, in seconds, in the Unix epoch format.   | 
| `mktime(time_zone, year, month, day_of_month, hour, minute, second)` | Returns the input time in seconds, in the Unix epoch format.<br />The following requirements apply for using this function:+  The time zone argument must be a quoted string (`'UTC'`). If not specified, the default time zone is UTC. <br />The time zone argument can be the first or last argument. <br />+  The year, month, day of month, hour, minute, and second arguments must be in order. <br />+  The year, month, and date arguments are required. <br />The following limits apply for using this function:+  `year` - Valid values are between 1970 and 2250. <br />+  `month` - Valid values are between 1 and 12. <br />+  `day-of-month` - Valid values are between 1 - 31. <br />+  `hour` - Valid values are between 0 and 23. <br />+  `minute` - Valid values are between 0 and 59. <br />+  `second` - Valid values are between 0 and 60. It can be a floating point number. <br />Examples:+  `mktime(2020, 2, 29)` <br />+  `mktime('UTC+3', 2021, 12, 31, 22)` <br />+  `mktime(2022, 10, 13, 2, 55, 13.68, 'PST')`  | 
| `localtime(unix_time, time_zone)` | Returns the year, the day of the month, the day of the week, the day of the year, the hour, the minute, or the second in the specified time zone from the Unix time.<br />The following requirements apply for using this function:+  The time zone argument must be a quoted string (`'UTC'`). If not specified, the default time zone is UTC. <br />+  The Unix time argument is the time in seconds, in the Unix epoch format. The valid range is between 1-31556889864403199. It can be a floating point number. <br />Example response: `2007-12-03T10:15:30+01:00[Europe/Paris]`<br />`localtime(unix_time, time_zone)` isn't a standalone function. The `year()`, `mon()`, `mday`, `wday()`, `yday()`, `hour()`, `minute()`, and `sec()` functions take `localtime(unix_time, time_zone)` as an argument.<br />Examples:+  `year(localtime('GMT', 1605898608.8113723))` <br />+  `now().localtime().year()` <br />+  `timestamp().localtime(‘PST’).year()` <br />+  `localtime(1605289736, ‘Europe/London’).year()`  | 
| `year(localtime(unix_time, time_zone)` | Returns the year from `localtime(unix_time, time_zone)`. | 
| `mon(localtime(unix_time, time_zone))` | Returns the month from `localtime(unix_time, time_zone)`. | 
| `mday(localtime(unix_time, time_zone))` | Returns the day of the month from `localtime(unix_time, time_zone)`. | 
| `wday(localtime(unix_time, time_zone))` | Returns the day of the week from `localtime(unix_time, time_zone)`. | 
| `yday(localtime(unix_time, time_zone))` | Returns the day of the year from `localtime(unix_time, time_zone)`. | 
| `hour(localtime(unix_time, time_zone))` | Returns the hour from `localtime(unix_time, time_zone)`. | 
| `minute(localtime(unix_time, time_zone))` | Returns the minute from `localtime(unix_time, time_zone)`. | 
| `sec(localtime(unix_time, time_zone))` | Returns the second from `localtime(unix_time, time_zone)`. | 

## Supported time zone formats
<a name="time-zone-expressions"></a>

You can specify the time zone argument in the following ways:
+ Time zone offset - Specify `'Z'` for UTC or an offset (`'+2'` or `'-5'`).
+ Offset IDs - Combine a time zone abbreviation and an offset. For example, `'GMT+2'` and `'UTC-01:00'`. The time zone abbreviation must contain only three letters.
+ Region based IDs - For example, `'Etc/GMT+12'` and `'Pacific/Pago_Pago'`.

### Supported time zone abbreviations
<a name="spported-time-zones"></a>

The date and time functions support the following three-letter time zone abbreviations: 
+ EST - -05:00
+ HST - -10:00
+ MST - -07:00
+ ACT - Australia/Darwin
+ AET - Australia/Sydney
+ AGT - America/Argentina/Buenos\_Aires
+ ART - Africa/Cairo
+ AST - America/Anchorage
+ BET - America/Sao\_Paulo
+ BST - Asia/Dhaka
+ CAT - Africa/Harare
+ CET - Europe/Paris
+ CNT - America/St\_Johns
+ CST - America/Chicago
+ CTT - Asia/Shanghai 
+ EAT - Africa/Addis\_Ababa
+ IET - America/Indiana/Indianapolis
+ IST - Asia/Kolkata
+ JST - Asia/Tokyo
+ MIT - Pacific/Apia
+ NET - Asia/Yerevan
+ NST - Pacific/Auckland
+ PLT - Asia/Karachi
+ PRT - America/Puerto\_Rico
+ PST - America/Los\_Angeles
+ SST - Pacific/Guadalcanal
+ VST - Asia/Ho\_Chi\_Minh

### Supported Region-based IDs
<a name="supported-region-based-ids"></a>

The date and time functions support the following Region-based IDs, organized by their relation to UTC\+00:00:
+ Etc/GMT\+12 (UTC-12:00)
+ Pacific/Pago\_Pago (UTC-11:00)
+ Pacific/Samoa (UTC-11:00)
+ Pacific/Niue (UTC-11:00)
+ US/Samoa (UTC-11:00)
+ Etc/GMT\+11 (UTC-11:00)
+ Pacific/Midway (UTC-11:00)
+ Pacific/Honolulu (UTC-10:00)
+ Pacific/Rarotonga (UTC-10:00)
+ Pacific/Tahiti (UTC-10:00)
+ Pacific/Johnston (UTC-10:00)
+ US/Hawaii (UTC-10:00)
+ SystemV/HST10 (UTC-10:00)
+ Etc/GMT\+10 (UTC-10:00)
+ Pacific/Marquesas (UTC-09:30)
+ Etc/GMT\+9 (UTC-09:00)
+ Pacific/Gambier (UTC-09:00)
+ America/Atka (UTC-09:00)
+ SystemV/YST9 (UTC-09:00)
+ America/Adak (UTC-09:00)
+ US/Aleutian (UTC-09:00)
+ Etc/GMT\+8 (UTC-08:00)
+ US/Alaska (UTC-08:00)
+ America/Juneau (UTC-08:00)
+ America/Metlakatla (UTC-08:00)
+ America/Yakutat (UTC-08:00)
+ Pacific/Pitcairn (UTC-08:00)
+ America/Sitka (UTC-08:00)
+ America/Anchorage (UTC-08:00)
+ SystemV/PST8 (UTC-08:00)
+ America/Nome (UTC-08:00)
+ SystemV/YST9YDT (UTC-08:00)
+ Canada/Yukon (UTC-07:00)
+ US/Pacific-New (UTC-07:00)
+ Etc/GMT\+7 (UTC-07:00)
+ US/Arizona (UTC-07:00)
+ America/Dawson\_Creek (UTC-07:00)
+ Canada/Pacific (UTC-07:00)
+ PST8PDT (UTC-07:00)
+ SystemV/MST7 (UTC-07:00)
+ America/Dawson (UTC-07:00)
+ Mexico/BajaNorte (UTC-07:00)
+ America/Tijuana (UTC-07:00)
+ America/Creston (UTC-07:00)
+ America/Hermosillo (UTC-07:00)
+ America/Santa\_Isabel (UTC-07:00)
+ America/Vancouver (UTC-07:00)
+ America/Ensenada (UTC-07:00)
+ America/Phoenix (UTC-07:00)
+ America/Whitehorse (UTC-07:00)
+ America/Fort\_Nelson (UTC-07:00)
+ SystemV/PST8PDT (UTC-07:00)
+ America/Los\_Angeles (UTC-07:00)
+ US/Pacific (UTC-07:00)
+ America/El\_Salvador (UTC-06:00)
+ America/Guatemala (UTC-06:00)
+ America/Belize (UTC-06:00)
+ America/Managua (UTC-06:00)
+ America/Tegucigalpa (UTC-06:00)
+ Etc/GMT\+6 (UTC-06:00)
+ Pacific/Easter (UTC-06:00)
+ Mexico/BajaSur (UTC-06:00)
+ America/Regina (UTC-06:00)
+ America/Denver (UTC-06:00)
+ Pacific/Galapagos (UTC-06:00)
+ America/Yellowknife (UTC-06:00)
+ America/Swift\_Current (UTC-06:00)
+ America/Inuvik (UTC-06:00)
+ America/Mazatlan (UTC-06:00)
+ America/Boise (UTC-06:00)
+ America/Costa\_Rica (UTC-06:00)
+ MST7MDT (UTC-06:00)
+ SystemV/CST6 (UTC-06:00)
+ America/Chihuahua (UTC-06:00)
+ America/Ojinaga (UTC-06:00)
+ Chile/EasterIsland (UTC-06:00)
+ US/Mountain (UTC-06:00)
+ America/Edmonton (UTC-06:00)
+ Canada/Mountain (UTC-06:00)
+ America/Cambridge\_Bay (UTC-06:00)
+ Navajo (UTC-06:00)
+ SystemV/MST7MDT (UTC-06:00)
+ Canada/Saskatchewan (UTC-06:00)
+ America/Shiprock (UTC-06:00)
+ America/Panama (UTC-05:00)
+ America/Chicago (UTC-05:00)
+ America/Eirunepe (UTC-05:00)
+ Etc/GMT\+5 (UTC-05:00)
+ Mexico/General (UTC-05:00)
+ America/Porto\_Acre (UTC-05:00)
+ America/Guayaquil (UTC-05:00)
+ America/Rankin\_Inlet (UTC-05:00)
+ US/Central (UTC-05:00)
+ America/Rainy\_River (UTC-05:00)
+ America/Indiana/Knox (UTC-05:00)
+ America/North\_Dakota/Beulah (UTC-05:00)
+ America/Monterrey (UTC-05:00)
+ America/Jamaica (UTC-05:00)
+ America/Atikokan (UTC-05:00)
+ America/Coral\_Harbour (UTC-05:00)
+ America/North\_Dakota/Center (UTC-05:00)
+ America/Cayman (UTC-05:00)
+ America/Indiana/Tell\_City (UTC-05:00)
+ America/Mexico\_City (UTC-05:00)
+ America/Matamoros (UTC-05:00)
+ CST6CDT (UTC-05:00)
+ America/Knox\_IN (UTC-05:00)
+ America/Bogota (UTC-05:00)
+ America/Menominee (UTC-05:00)
+ America/Resolute (UTC-05:00)
+ SystemV/EST5 (UTC-05:00)
+ Canada/Central (UTC-05:00)
+ Brazil/Acre (UTC-05:00)
+ America/Cancun (UTC-05:00)
+ America/Lima (UTC-05:00)
+ America/Bahia\_Banderas (UTC-05:00)
+ US/Indiana-Starke (UTC-05:00)
+ America/Rio\_Branco (UTC-05:00)
+ SystemV/CST6CDT (UTC-05:00)
+ Jamaica (UTC-05:00)
+ America/Merida (UTC-05:00)
+ America/North\_Dakota/New\_Salem (UTC-05:00)
+ America/Winnipeg (UTC-05:00)
+ America/Cuiaba (UTC-04:00)
+ America/Marigot (UTC-04:00)
+ America/Indiana/Petersburg (UTC-04:00)
+ Chile/Continental (UTC-04:00)
+ America/Grand\_Turk (UTC-04:00)
+ Cuba (UTC-04:00)
+ Etc/GMT\+4 (UTC-04:00)
+ America/Manaus (UTC-04:00)
+ America/Fort\_Wayne (UTC-04:00)
+ America/St\_Thomas (UTC-04:00)
+ America/Anguilla (UTC-04:00)
+ America/Havana (UTC-04:00)
+ US/Michigan (UTC-04:00)
+ America/Barbados (UTC-04:00)
+ America/Louisville (UTC-04:00)
+ America/Curacao (UTC-04:00)
+ America/Guyana (UTC-04:00)
+ America/Martinique (UTC-04:00)
+ America/Puerto\_Rico (UTC-04:00)
+ America/Port\_of\_Spain (UTC-04:00)
+ SystemV/AST4 (UTC-04:00)
+ America/Indiana/Vevay (UTC-04:00)
+ America/Indiana/Vincennes (UTC-04:00)
+ America/Kralendijk (UTC-04:00)
+ America/Antigua (UTC-04:00)
+ America/Indianapolis (UTC-04:00)
+ America/Iqaluit (UTC-04:00)
+ America/St\_Vincent (UTC-04:00)
+ America/Kentucky/Louisville (UTC-04:00)
+ America/Dominica (UTC-04:00)
+ America/Asuncion (UTC-04:00)
+ EST5EDT (UTC-04:00)
+ America/Nassau (UTC-04:00)
+ America/Kentucky/Monticello (UTC-04:00)
+ Brazil/West (UTC-04:00)
+ America/Aruba (UTC-04:00)
+ America/Indiana/Indianapolis (UTC-04:00)
+ America/Santiago (UTC-04:00)
+ America/La\_Paz (UTC-04:00)
+ America/Thunder\_Bay (UTC-04:00)
+ America/Indiana/Marengo (UTC-04:00)
+ America/Blanc-Sablon (UTC-04:00)
+ America/Santo\_Domingo (UTC-04:00)
+ US/Eastern (UTC-04:00)
+ Canada/Eastern (UTC-04:00)
+ America/Port-au-Prince (UTC-04:00)
+ America/St\_Barthelemy (UTC-04:00)
+ America/Nipigon (UTC-04:00)
+ US/East-Indiana (UTC-04:00)
+ America/St\_Lucia (UTC-04:00)
+ America/Montserrat (UTC-04:00)
+ America/Lower\_Princes (UTC-04:00)
+ America/Detroit (UTC-04:00)
+ America/Tortola (UTC-04:00)
+ America/Porto\_Velho (UTC-04:00)
+ America/Campo\_Grande (UTC-04:00)
+ America/Virgin (UTC-04:00)
+ America/Pangnirtung (UTC-04:00)
+ America/Montreal (UTC-04:00)
+ America/Indiana/Winamac (UTC-04:00)
+ America/Boa\_Vista (UTC-04:00)
+ America/Grenada (UTC-04:00)
+ America/New\_York (UTC-04:00)
+ America/St\_Kitts (UTC-04:00)
+ America/Caracas (UTC-04:00)
+ America/Guadeloupe (UTC-04:00)
+ America/Toronto (UTC-04:00)
+ SystemV/EST5EDT (UTC-04:00)
+ America/Argentina/Catamarca (UTC-03:00)
+ Canada/Atlantic (UTC-03:00)
+ America/Argentina/Cordoba (UTC-03:00)
+ America/Araguaina (UTC-03:00)
+ America/Argentina/Salta (UTC-03:00)
+ Etc/GMT\+3 (UTC-03:00)
+ America/Montevideo (UTC-03:00)
+ Brazil/East (UTC-03:00)
+ America/Argentina/Mendoza (UTC-03:00)
+ America/Argentina/Rio\_Gallegos (UTC-03:00)
+ America/Catamarca (UTC-03:00)
+ America/Cordoba (UTC-03:00)
+ America/Sao\_Paulo (UTC-03:00)
+ America/Argentina/Jujuy (UTC-03:00)
+ America/Cayenne (UTC-03:00)
+ America/Recife (UTC-03:00)
+ America/Buenos\_Aires (UTC-03:00)
+ America/Paramaribo (UTC-03:00)
+ America/Moncton (UTC-03:00)
+ America/Mendoza (UTC-03:00)
+ America/Santarem (UTC-03:00)
+ Atlantic/Bermuda (UTC-03:00)
+ America/Maceio (UTC-03:00)
+ Atlantic/Stanley (UTC-03:00)
+ America/Halifax (UTC-03:00)
+ Antarctica/Rothera (UTC-03:00)
+ America/Argentina/San\_Luis (UTC-03:00)
+ America/Argentina/Ushuaia (UTC-03:00)
+ Antarctica/Palmer (UTC-03:00)
+ America/Punta\_Arenas (UTC-03:00)
+ America/Glace\_Bay (UTC-03:00)
+ America/Fortaleza (UTC-03:00)
+ America/Thule (UTC-03:00)
+ America/Argentina/La\_Rioja (UTC-03:00)
+ America/Belem (UTC-03:00)
+ America/Jujuy (UTC-03:00)
+ America/Bahia (UTC-03:00)
+ America/Goose\_Bay (UTC-03:00)
+ America/Argentina/San\_Juan (UTC-03:00)
+ America/Argentina/ComodRivadavia (UTC-03:00)
+ America/Argentina/Tucuman (UTC-03:00)
+ America/Rosario (UTC-03:00)
+ SystemV/AST4ADT (UTC-03:00)
+ America/Argentina/Buenos\_Aires (UTC-03:00)
+ America/St\_Johns (UTC-02:30)
+ Canada/Newfoundland (UTC-02:30)
+ America/Miquelon (UTC-02:00)
+ Etc/GMT\+2 (UTC-02:00)
+ America/Godthab (UTC-02:00)
+ America/Noronha (UTC-02:00)
+ Brazil/DeNoronha (UTC-02:00)
+ Atlantic/South\_Georgia (UTC-02:00)
+ Etc/GMT\+1 (UTC-01:00)
+ Atlantic/Cape\_Verde (UTC-01:00)
+ Pacific/Kiritimati (UTC\+14:00)
+ Etc/GMT-14 (UTC\+14:00)
+ Pacific/Fakaofo (UTC\+13:00)
+ Pacific/Enderbury (UTC\+13:00)
+ Pacific/Apia (UTC\+13:00)
+ Pacific/Tongatapu (UTC\+13:00)
+ Etc/GMT-13 (UTC\+13:00)
+ NZ-CHAT (UTC\+12:45)
+ Pacific/Chatham (UTC\+12:45)
+ Pacific/Kwajalein (UTC\+12:00)
+ Antarctica/McMurdo (UTC\+12:00)
+ Pacific/Wallis (UTC\+12:00)
+ Pacific/Fiji (UTC\+12:00)
+ Pacific/Funafuti (UTC\+12:00)
+ Pacific/Nauru (UTC\+12:00)
+ Kwajalein (UTC\+12:00)
+ NZ (UTC\+12:00)
+ Pacific/Wake (UTC\+12:00)
+ Antarctica/South\_Pole (UTC\+12:00)
+ Pacific/Tarawa (UTC\+12:00)
+ Pacific/Auckland (UTC\+12:00)
+ Asia/Kamchatka (UTC\+12:00)
+ Etc/GMT-12 (UTC\+12:00)
+ Asia/Anadyr (UTC\+12:00)
+ Pacific/Majuro (UTC\+12:00)
+ Pacific/Ponape (UTC\+11:00)
+ Pacific/Bougainville (UTC\+11:00)
+ Antarctica/Macquarie (UTC\+11:00)
+ Pacific/Pohnpei (UTC\+11:00)
+ Pacific/Efate (UTC\+11:00)
+ Pacific/Norfolk (UTC\+11:00)
+ Asia/Magadan (UTC\+11:00)
+ Pacific/Kosrae (UTC\+11:00)
+ Asia/Sakhalin (UTC\+11:00)
+ Pacific/Noumea (UTC\+11:00)
+ Etc/GMT-11 (UTC\+11:00)
+ Asia/Srednekolymsk (UTC\+11:00)
+ Pacific/Guadalcanal (UTC\+11:00)
+ Australia/Lord\_Howe (UTC\+10:30)
+ Australia/LHI (UTC\+10:30)
+ Australia/Hobart (UTC\+10:00)
+ Pacific/Yap (UTC\+10:00)
+ Australia/Tasmania (UTC\+10:00)
+ Pacific/Port\_Moresby (UTC\+10:00)
+ Australia/ACT (UTC\+10:00)
+ Australia/Victoria (UTC\+10:00)
+ Pacific/Chuuk (UTC\+10:00)
+ Australia/Queensland (UTC\+10:00)
+ Australia/Canberra (UTC\+10:00)
+ Australia/Currie (UTC\+10:00)
+ Pacific/Guam (UTC\+10:00)
+ Pacific/Truk (UTC\+10:00)
+ Australia/NSW (UTC\+10:00)
+ Asia/Vladivostok (UTC\+10:00)
+ Pacific/Saipan (UTC\+10:00)
+ Antarctica/DumontDUrville (UTC\+10:00)
+ Australia/Sydney (UTC\+10:00)
+ Australia/Brisbane (UTC\+10:00)
+ Etc/GMT-10 (UTC\+10:00)
+ Asia/Ust-Nera (UTC\+10:00)
+ Australia/Melbourne (UTC\+10:00)
+ Australia/Lindeman (UTC\+10:00)
+ Australia/North (UTC\+09:30)
+ Australia/Yancowinna (UTC\+09:30)
+ Australia/Adelaide (UTC\+09:30)
+ Australia/Broken\_Hill (UTC\+09:30)
+ Australia/South (UTC\+09:30)
+ Australia/Darwin (UTC\+09:30)
+ Etc/GMT-9 (UTC\+09:00)
+ Pacific/Palau (UTC\+09:00)
+ Asia/Chita (UTC\+09:00)
+ Asia/Dili (UTC\+09:00)
+ Asia/Jayapura (UTC\+09:00)
+ Asia/Yakutsk (UTC\+09:00)
+ Asia/Pyongyang (UTC\+09:00)
+ ROK (UTC\+09:00)
+ Asia/Seoul (UTC\+09:00)
+ Asia/Khandyga (UTC\+09:00)
+ Japan (UTC\+09:00)
+ Asia/Tokyo (UTC\+09:00)
+ Australia/Eucla (UTC\+08:45)
+ Asia/Kuching (UTC\+08:00)
+ Asia/Chungking (UTC\+08:00)
+ Etc/GMT-8 (UTC\+08:00)
+ Australia/Perth (UTC\+08:00)
+ Asia/Macao (UTC\+08:00)
+ Asia/Macau (UTC\+08:00)
+ Asia/Choibalsan (UTC\+08:00)
+ Asia/Shanghai (UTC\+08:00)
+ Antarctica/Casey (UTC\+08:00)
+ Asia/Ulan\_Bator (UTC\+08:00)
+ Asia/Chongqing (UTC\+08:00)
+ Asia/Ulaanbaatar (UTC\+08:00)
+ Asia/Taipei (UTC\+08:00)
+ Asia/Manila (UTC\+08:00)
+ PRC (UTC\+08:00)
+ Asia/Ujung\_Pandang (UTC\+08:00)
+ Asia/Harbin (UTC\+08:00)
+ Singapore (UTC\+08:00)
+ Asia/Brunei (UTC\+08:00)
+ Australia/West (UTC\+08:00)
+ Asia/Hong\_Kong (UTC\+08:00)
+ Asia/Makassar (UTC\+08:00)
+ Hongkong (UTC\+08:00)
+ Asia/Kuala\_Lumpur (UTC\+08:00)
+ Asia/Irkutsk (UTC\+08:00)
+ Asia/Singapore (UTC\+08:00)
+ Asia/Pontianak (UTC\+07:00)
+ Etc/GMT-7 (UTC\+07:00)
+ Asia/Phnom\_Penh (UTC\+07:00)
+ Asia/Novosibirsk (UTC\+07:00)
+ Antarctica/Davis (UTC\+07:00)
+ Asia/Tomsk (UTC\+07:00)
+ Asia/Jakarta (UTC\+07:00)
+ Asia/Barnaul (UTC\+07:00)
+ Indian/Christmas (UTC\+07:00)
+ Asia/Ho\_Chi\_Minh (UTC\+07:00)
+ Asia/Hovd (UTC\+07:00)
+ Asia/Bangkok (UTC\+07:00)
+ Asia/Vientiane (UTC\+07:00)
+ Asia/Novokuznetsk (UTC\+07:00)
+ Asia/Krasnoyarsk (UTC\+07:00)
+ Asia/Saigon (UTC\+07:00)
+ Asia/Yangon (UTC\+06:30)
+ Asia/Rangoon (UTC\+06:30)
+ Indian/Cocos (UTC\+06:30)
+ Asia/Kashgar (UTC\+06:00)
+ Etc/GMT-6 (UTC\+06:00)
+ Asia/Almaty (UTC\+06:00)
+ Asia/Dacca (UTC\+06:00)
+ Asia/Omsk (UTC\+06:00)
+ Asia/Dhaka (UTC\+06:00)
+ Indian/Chagos (UTC\+06:00)
+ Asia/Qyzylorda (UTC\+06:00)
+ Asia/Bishkek (UTC\+06:00)
+ Antarctica/Vostok (UTC\+06:00)
+ Asia/Urumqi (UTC\+06:00)
+ Asia/Thimbu (UTC\+06:00)
+ Asia/Thimphu (UTC\+06:00)
+ Asia/Kathmandu (UTC\+05:45)
+ Asia/Katmandu (UTC\+05:45)
+ Asia/Kolkata (UTC\+05:30)
+ Asia/Colombo (UTC\+05:30)
+ Asia/Calcutta (UTC\+05:30)
+ Asia/Aqtau (UTC\+05:00)
+ Etc/GMT-5 (UTC\+05:00)
+ Asia/Samarkand (UTC\+05:00)
+ Asia/Karachi (UTC\+05:00)
+ Asia/Yekaterinburg (UTC\+05:00)
+ Asia/Dushanbe (UTC\+05:00)
+ Indian/Maldives (UTC\+05:00)
+ Asia/Oral (UTC\+05:00)
+ Asia/Tashkent (UTC\+05:00)
+ Antarctica/Mawson (UTC\+05:00)
+ Asia/Aqtobe (UTC\+05:00)
+ Asia/Ashkhabad (UTC\+05:00)
+ Asia/Ashgabat (UTC\+05:00)
+ Asia/Atyrau (UTC\+05:00)
+ Indian/Kerguelen (UTC\+05:00)
+ Iran (UTC\+04:30)
+ Asia/Tehran (UTC\+04:30)
+ Asia/Kabul (UTC\+04:30)
+ Asia/Yerevan (UTC\+04:00)
+ Etc/GMT-4 (UTC\+04:00)
+ Etc/GMT-4 (UTC\+04:00)
+ Asia/Dubai (UTC\+04:00)
+ Indian/Reunion (UTC\+04:00)
+ Europe/Saratov (UTC\+04:00)
+ Europe/Samara (UTC\+04:00)
+ Indian/Mahe (UTC\+04:00)
+ Asia/Baku (UTC\+04:00)
+ Asia/Muscat (UTC\+04:00)
+ Europe/Volgograd (UTC\+04:00)
+ Europe/Astrakhan (UTC\+04:00)
+ Asia/Tbilisi (UTC\+04:00)
+ Europe/Ulyanovsk (UTC\+04:00)
+ Asia/Aden (UTC\+03:00)
+ Africa/Nairobi (UTC\+03:00)
+ Europe/Istanbul (UTC\+03:00)
+ Etc/GMT-3 (UTC\+03:00)
+ Europe/Zaporozhye (UTC\+03:00)
+ Israel (UTC\+03:00)
+ Indian/Comoro (UTC\+03:00)
+ Antarctica/Syowa (UTC\+03:00)
+ Africa/Mogadishu (UTC\+03:00)
+ Europe/Bucharest (UTC\+03:00)
+ Africa/Asmera (UTC\+03:00)
+ Europe/Mariehamn (UTC\+03:00)
+ Asia/Istanbul (UTC\+03:00)
+ Europe/Tiraspol (UTC\+03:00)
+ Europe/Moscow (UTC\+03:00)
+ Europe/Chisinau (UTC\+03:00)
+ Europe/Helsinki (UTC\+03:00)
+ Asia/Beirut (UTC\+03:00)
+ Asia/Tel\_Aviv (UTC\+03:00)
+ Africa/Djibouti (UTC\+03:00)
+ Europe/Simferopol (UTC\+03:00)
+ Europe/Sofia (UTC\+03:00)
+ Asia/Gaza (UTC\+03:00)
+ Africa/Asmara (UTC\+03:00)
+ Europe/Riga (UTC\+03:00)
+ Asia/Baghdad (UTC\+03:00)
+ Asia/Damascus (UTC\+03:00)
+ Africa/Dar\_es\_Salaam (UTC\+03:00)
+ Africa/Addis\_Ababa (UTC\+03:00)
+ Europe/Uzhgorod (UTC\+03:00)
+ Asia/Jerusalem (UTC\+03:00)
+ Asia/Riyadh (UTC\+03:00)
+ Asia/Kuwait (UTC\+03:00)
+ Europe/Kirov (UTC\+03:00)
+ Africa/Kampala (UTC\+03:00)
+ Europe/Minsk (UTC\+03:00)
+ Asia/Qatar (UTC\+03:00)
+ Europe/Kiev (UTC\+03:00)
+ Asia/Bahrain (UTC\+03:00)
+ Europe/Vilnius (UTC\+03:00)
+ Indian/Antananarivo (UTC\+03:00)
+ Indian/Mayotte (UTC\+03:00)
+ Europe/Tallinn (UTC\+03:00)
+ Turkey (UTC\+03:00)
+ Africa/Juba (UTC\+03:00)
+ Asia/Nicosia (UTC\+03:00)
+ Asia/Famagusta (UTC\+03:00)
+ W-SU (UTC\+03:00)
+ EET (UTC\+03:00)
+ Asia/Hebron (UTC\+03:00)
+ Asia/Amman (UTC\+03:00)
+ Europe/Nicosia (UTC\+03:00)
+ Europe/Athens (UTC\+03:00)
+ Africa/Cairo (UTC\+02:00)
+ Africa/Mbabane (UTC\+02:00)
+ Europe/Brussels (UTC\+02:00)
+ Europe/Warsaw (UTC\+02:00)
+ CET (UTC\+02:00)
+ Europe/Luxembourg (UTC\+02:00)
+ Etc/GMT-2 (UTC\+02:00)
+ Libya (UTC\+02:00)
+ Africa/Kigali (UTC\+02:00)
+ Africa/Tripoli (UTC\+02:00)
+ Europe/Kaliningrad (UTC\+02:00)
+ Africa/Windhoek (UTC\+02:00)
+ Europe/Malta (UTC\+02:00)
+ Europe/Busingen (UTC\+02:00)
+ 
+ Europe/Skopje (UTC\+02:00)
+ Europe/Sarajevo (UTC\+02:00)
+ Europe/Rome (UTC\+02:00)
+ Europe/Zurich (UTC\+02:00)
+ Europe/Gibraltar (UTC\+02:00)
+ Africa/Lubumbashi (UTC\+02:00)
+ Europe/Vaduz (UTC\+02:00)
+ Europe/Ljubljana (UTC\+02:00)
+ Europe/Berlin (UTC\+02:00)
+ Europe/Stockholm (UTC\+02:00)
+ Europe/Budapest (UTC\+02:00)
+ Europe/Zagreb (UTC\+02:00)
+ Europe/Paris (UTC\+02:00)
+ Africa/Ceuta (UTC\+02:00)
+ Europe/Prague (UTC\+02:00)
+ Antarctica/Troll (UTC\+02:00)
+ Africa/Gaborone (UTC\+02:00)
+ Europe/Copenhagen (UTC\+02:00)
+ Europe/Vienna (UTC\+02:00)
+ Europe/Tirane (UTC\+02:00)
+ MET (UTC\+02:00)
+ Europe/Amsterdam (UTC\+02:00)
+ Africa/Maputo (UTC\+02:00)
+ Europe/San\_Marino (UTC\+02:00)
+ Poland (UTC\+02:00)
+ Europe/Andorra (UTC\+02:00)
+ Europe/Oslo (UTC\+02:00)
+ Europe/Podgorica (UTC\+02:00)
+ Africa/Bujumbura (UTC\+02:00)
+ Atlantic/Jan\_Mayen (UTC\+02:00)
+ Africa/Maseru (UTC\+02:00)
+ Europe/Madrid (UTC\+02:00)
+ Africa/Blantyre (UTC\+02:00)
+ Africa/Lusaka (UTC\+02:00)
+ Africa/Harare (UTC\+02:00)
+ Africa/Khartoum (UTC\+02:00)
+ Africa/Johannesburg (UTC\+02:00)
+ Europe/Belgrade (UTC\+02:00)
+ Europe/Bratislava (UTC\+02:00)
+ Arctic/Longyearbyen (UTC\+02:00)
+ Egypt (UTC\+02:00)
+ Europe/Vatican (UTC\+02:00)
+ Europe/Monaco (UTC\+02:00)
+ Europe/London (UTC\+01:00)
+ Etc/GMT-1 (UTC\+01:00)
+ Europe/Jersey (UTC\+01:00)
+ Europe/Guernsey (UTC\+01:00)
+ Europe/Isle\_of\_Man (UTC\+01:00)
+ Africa/Tunis (UTC\+01:00)
+ Africa/Malabo (UTC\+01:00)
+ GB-Eire (UTC\+01:00)
+ Africa/Lagos (UTC\+01:00)
+ Africa/Algiers (UTC\+01:00)
+ GB (UTC\+01:00)
+ Portugal (UTC\+01:00)
+ Africa/Sao\_Tome (UTC\+01:00)
+ Africa/Ndjamena (UTC\+01:00)
+ Atlantic/Faeroe (UTC\+01:00)
+ Eire (UTC\+01:00)
+ Atlantic/Faroe (UTC\+01:00)
+ Europe/Dublin (UTC\+01:00)
+ Africa/Libreville (UTC\+01:00)
+ Africa/El\_Aaiun (UTC\+01:00)
+ Africa/El\_Aaiun (UTC\+01:00)
+ Africa/Douala (UTC\+01:00)
+ Africa/Brazzaville (UTC\+01:00)
+ Africa/Porto-Novo (UTC\+01:00)
+ Atlantic/Madeira (UTC\+01:00)
+ Europe/Lisbon (UTC\+01:00)
+ Atlantic/Canary (UTC\+01:00)
+ Africa/Casablanca (UTC\+01:00)
+ Europe/Belfast (UTC\+01:00)
+ Africa/Luanda (UTC\+01:00)
+ Africa/Kinshasa (UTC\+01:00)
+ Africa/Bangui (UTC\+01:00)
+ WET (UTC\+01:00)
+ Africa/Niamey (UTC\+01:00)
+ GMT (UTC\+00:00)
+ Etc/GMT-0 (UTC\+00:00)
+ Atlantic/St\_Helena (UTC\+00:00)
+ Etc/GMT\+0 (UTC\+00:00)
+ Africa/Banjul (UTC\+00:00)
+ Etc/GMT (UTC\+00:00)
+ Africa/Freetown (UTC\+00:00)
+ Africa/Bamako (UTC\+00:00)
+ Africa/Conakry (UTC\+00:00)
+ Universal (UTC\+00:00)
+ Africa/Nouakchott (UTC\+00:00)
+ UTC (UTC\+00:00)
+ Etc/Universal (UTC\+00:00)
+ Atlantic/Azores (UTC\+00:00)
+ Africa/Abidjan (UTC\+00:00)
+ Africa/Accra (UTC\+00:00)
+ Etc/UCT (UTC\+00:00)
+ GMT0 (UTC\+00:00)
+ Zulu (UTC\+00:00)Zulu (UTC\+00:00)
+ Africa/Ouagadougou (UTC\+00:00)
+ Atlantic/Reykjavik (UTC\+00:00)
+ Etc/Zulu (UTC\+00:00)
+ Iceland (UTC\+00:00)
+ Africa/Lome (UTC\+00:00)
+ Greenwich (UTC\+00:00)
+ Etc/GMT0 (UTC\+00:00)
+ America/Danmarkshavn (UTC\+00:00)
+ Africa/Dakar (UTC\+00:00)
+ Africa/Bissau (UTC\+00:00)
+ Etc/Greenwich (UTC\+00:00)
+ Africa/Timbuktu (UTC\+00:00)
+ UCT (UTC\+00:00)
+ Africa/Monrovia (UTC\+00:00)
+ Etc/UTC (UTC\+00:00)