

As traduções são geradas por tradução automática. Em caso de conflito entre o conteúdo da tradução e da versão original em inglês, a versão em inglês prevalecerá.

# Usar funções de data e hora em expressões de fórmula
<a name="expression-date-and-time-functions"></a>

Em [transformações](transforms.md) e [métricas](metrics.md), você pode usar as funções de data e hora das seguintes formas:
+ Recupere o a função de hora atual de um ponto de dados em UTC ou no fuso horário local.
+ Estruture a função de horas com argumentos, como `year`, `month` e `day_of_month`.
+ Extraia um período de tempo, como um ano ou mês, com o argumento `unix_time`.


| Função | Description | 
| --- | --- | 
| `now()` | Retorna a data e a hora atuais, em segundos, no formato Unix epoch. | 
| `timestamp()` |  +  Em transformações, a função retorna a função de hora, em segundos, da mensagem de entrada no formato Unix epoch. <br />Somente em transformações, você pode realizar uma das seguintes ações:   Fornecer uma variável como argumento para a função. A função `timestamp({{variable-name}})` retorna a função de hora, em segundos, do valor de qualidade `GOOD` mais recente para a variável especificada no formato Unix epoch. <br />Por exemplo, se seu ativo tiver uma propriedade de transformação chamada `Temperature_F` que use a fórmula `9/5 * Temperature_C` para converter cada ponto de dados de temperatura de Celsius para Fahrenheit, você pode usar a função `timestamp(Temperature_F)` para obter a função de hora do valor de qualidade mais recente `GOOD` da propriedade `Temperature_F`.   Use a função `pretrigger()` como argumento para a função. A função `timestamp(pretrigger({{variable-name}}))` retorna a função de hora, em segundos, do valor de qualidade `GOOD` da variável especificada [3] antes da atualização da propriedade que iniciou o cálculo da transformação atual, no formato Unix epoch. Para obter mais informações, consulte [Usar funções temporais em transformações](expression-temporal-functions.md#temporal-functions-in-transforms).   <br />+  Nas métricas, a função retorna a função de hora recuperada no final da janela atual, em segundos, no formato Unix epoch.   | 
| `mktime(time_zone, year, month, day_of_month, hour, minute, second)` | Retorna o tempo de entrada, em segundos, no formato Unix epoch.<br />Os seguintes requisitos se aplicam ao usar essa função:+  O argumento do fuso horário deve ser uma string entre aspas (`'UTC'`). Se não especificado, o fuso horário padrão será UTC. <br />O argumento do fuso horário pode ser o primeiro ou o último argumento. <br />+  Os argumentos de ano, mês, dia do mês, hora, minuto e segundo devem estar em ordem. <br />+  Os argumentos de ano, mês e data são obrigatórios. <br />Os seguintes limites se aplicam ao usar essa função:+  `year` - valores válidos estão entre 1970 e 2250. <br />+  `month` - valores válidos estão entre 1 e 12. <br />+  `day-of-month` - valores válidos estão entre 1 e 31. <br />+  `hour` - valores válidos estão entre 0 e 23. <br />+  `minute` - valores válidos estão entre 0 e 59. <br />+  `second` - valores válidos estão entre 0 e 60. Ele pode ser um número de ponto flutuante. <br />Exemplos:+  `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)` | Retorna o ano, o dia do mês, o dia da semana, o dia do ano, a hora, o minuto ou o segundo no fuso horário especificado, a partir do horário Unix.<br />Os seguintes requisitos se aplicam ao usar essa função:+  O argumento do fuso horário deve ser uma string entre aspas (`'UTC'`). Se não especificado, o fuso horário padrão será UTC. <br />+  O argumento Unix time é a hora em segundos, no formato Unix epoch. O intervalo válido é entre 1-31556889864403199. Ele pode ser um número de ponto flutuante. <br />Exemplo de resposta: `2007-12-03T10:15:30+01:00[Europe/Paris]`<br />`localtime(unix_time, time_zone)` não é uma função independente. As funções `year()`, `mon()`, `mday`, `wday()`, `yday()`, `hour()`, `minute()` e `sec()` usam `localtime(unix_time, time_zone)` como argumento.<br />Exemplos:+  `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)` | Retorna o ano de `localtime(unix_time, time_zone)`. | 
| `mon(localtime(unix_time, time_zone))` | Retorna o mês a partir de `localtime(unix_time, time_zone)`. | 
| `mday(localtime(unix_time, time_zone))` | Retorna o dia do mês a partir de `localtime(unix_time, time_zone)`. | 
| `wday(localtime(unix_time, time_zone))` | Retorna o dia da semana a partir de `localtime(unix_time, time_zone)`. | 
| `yday(localtime(unix_time, time_zone))` | Retorna o dia do ano a partir de `localtime(unix_time, time_zone)`. | 
| `hour(localtime(unix_time, time_zone))` | Retorna a hora a partir de `localtime(unix_time, time_zone)`. | 
| `minute(localtime(unix_time, time_zone))` | Retorna o minuto a partir de `localtime(unix_time, time_zone)`. | 
| `sec(localtime(unix_time, time_zone))` | Retorna o segundo a partir de `localtime(unix_time, time_zone)`. | 

## Formatos de fuso horário suportados
<a name="time-zone-expressions"></a>

É possível especificar o argumento de fuso horário das seguintes maneiras:
+ Deslocamento de fuso horário - especifique `'Z'` para UTC ou um deslocamento (`'+2'` ou`'-5'`). 
+ IDs de deslocamento - Combine uma abreviatura de fuso horário e um deslocamento. Por exemplo, `'GMT+2'` e `'UTC-01:00'`. A abreviatura do fuso horário deve conter apenas três letras.
+ IDs baseadas na região - por exemplo, `'Etc/GMT+12'` e `'Pacific/Pago_Pago'`.

### Abreviações de fuso horário compatíveis
<a name="spported-time-zones"></a>

As funções de data e hora oferecem suporte às seguintes abreviações de fuso horário de três letras: 
+ EST - - 05:00
+ HST - - 10:00
+ MST - - 07:00
+ AGIR - Australia/Darwin
+ AET - Australia/Sydney
+ AGT - \_Aires America/Argentina/Buenos
+ ARTE - Africa/Cairo
+ AST - America/Anchorage
+ BET - America/Sao \_Paulo
+ MELHOR - Asia/Dhaka
+ GATO - Africa/Harare
+ CET - Europe/Paris
+ CNT - \_Johns America/St
+ CST - America/Chicago
+ CTT - Asia/Shanghai 
+ EAT - Africa/Addis \_Ababa
+ DIETA - America/Indiana/Indianapolis
+ IST - Asia/Kolkata
+ JST - Asia/Tokyo
+ MIT - Pacific/Apia
+ REDE - Asia/Yerevan
+ NST - Pacific/Auckland
+ PLT - Asia/Karachi
+ PRT - \_Rico America/Puerto
+ PST - \_Angeles America/Los
+ SST - Pacific/Guadalcanal
+ IVA - \_ Asia/Ho Chi\_Minh

### Region-based IDs compatíveis
<a name="supported-region-based-ids"></a>

As funções de data e hora suportam os seguintes Region-based IDs, organizados por sua relação com 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\_Riacho () UTC-07:00
+ Canada/Pacific (UTC-07:00)
+ PST 8 PDT () 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\_Atual () 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\_Baía () UTC-06:00
+ Navajo (1) 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\_Entrada () UTC-05:00
+ US/Central (UTC-05:00)
+ America/Rainy\_Rio () 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\_Porto () UTC-05:00
+ America/North\_Dakota/Center (UTC-05:00)
+ America/Cayman (UTC-05:00)
+ America/Indiana/Tell\_Cidade () UTC-05:00
+ America/Mexico\_Cidade () UTC-05:00
+ America/Matamoros (UTC-05:00)
+ CST6CDT () UTC-05:00
+ America/Knox\_EM () 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\_Bandeiras () 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\_Turco () UTC-04:00
+ Cuba (1UTC-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\_de\_Espanha () 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\_Baía () 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\_Barthélemy () UTC-04:00
+ America/Nipigon (UTC-04:00)
+ US/East-Indiana (UTC-04:00)
+ America/St\_Lúcia () UTC-04:00
+ America/Montserrat (UTC-04:00)
+ America/Lower\_Príncipes () 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\_Cristóvão () 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\_Galegos () 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\_Luís () UTC-03:00
+ America/Argentina/Ushuaia (UTC-03:00)
+ Antarctica/Palmer (UTC-03:00)
+ America/Punta\_Arenas () UTC-03:00
+ America/Glace\_Baía () 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\_Baía () UTC-03:00
+ America/Argentina/San\_João () 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\_Geórgia () 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)
+ Japão (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)
+ Cingapura (UTC \+ 08:00)
+ Asia/Brunei (UTC\+ 08:00)
+ Australia/West (UTC\+ 08:00)
+ Asia/Hong\_Kong (UTC\+ 08:00)
+ Asia/Makassar (UTC\+ 08:00)
+ Hong Kong (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)
+ Irã (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\_Abeba (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)
+ Turquia (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)
+ Líbia (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 \+ 03:00)
+ Europe/Amsterdam (UTC\+ 02:00)
+ Africa/Maputo (UTC\+ 02:00)
+ Europe/San\_Marino (UTC\+ 02:00)
+ Polônia (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)
+ Egito (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\_de\_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\_Tomé (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)
+ GMT 0 (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)
+ Islândia (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)