View a markdown version of this page

Usar funções de data e hora em expressões de fórmula - AWS IoT SiteWise
Formatos de fuso horário suportados

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

Em transformações e métricas, 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.

    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.

      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.

  • 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.

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.

    O argumento do fuso horário pode ser o primeiro ou o último argumento.

  • Os argumentos de ano, mês, dia do mês, hora, minuto e segundo devem estar em ordem.

  • Os argumentos de ano, mês e data são obrigatórios.

Os seguintes limites se aplicam ao usar essa função:

  • year - valores válidos estão entre 1970 e 2250.

  • month - valores válidos estão entre 1 e 12.

  • day-of-month - valores válidos estão entre 1 e 31.

  • hour - valores válidos estão entre 0 e 23.

  • minute - valores válidos estão entre 0 e 59.

  • second - valores válidos estão entre 0 e 60. Ele pode ser um número de ponto flutuante.

Exemplos:

  • mktime(2020, 2, 29)

  • mktime('UTC+3', 2021, 12, 31, 22)

  • 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.

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.

  • 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.

Exemplo de resposta: 2007-12-03T10:15:30+01:00[Europe/Paris]

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.

Exemplos:

  • year(localtime('GMT', 1605898608.8113723))

  • now().localtime().year()

  • timestamp().localtime(‘PST’).year()

  • 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

É 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'.

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

  • APENAS - 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

As funções de data e hora oferecem suporte aos seguintes Region-based IDs, organizados por sua relação com UTC+ 00:00:

  • Etc/GMT+12 () UTC-12:00

  • Pacific/Pago_Pagamento () 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 (2) 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 (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_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)

  • EST 5 EDT (1) 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_Barthelemy () 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_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_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_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_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_pt_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_Horário (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)