Time Zones

Introduction

By default All TQL queries are executed in the context of the servers configured time-zone.

As of version 4.6 of Enterprise Tester, we now allow the time-zone to be overriden when searching for or aggregating over date/time values (such as when grouping by day), ensuring you get the results you would expect when using the API.

The methods in which the timezone can be set are:

  • Passing the "timeZone" query parameter (supported by API resources which allow execution of TQL queries e.g. /api/search?tql=query&timeZone=tz)
  • Adding the "TimeZone" property to the specification object being submitted (using by the Grid Widget Data resources currently).
  • Using the "TimeZone" query hint, via SET in your TQL query.

The query hint can be supplied by prefixing your existing query with the timezone hint, so if you had the query:

GROUP BY Day(CreatedAt) { COUNT }

You could change the timezone the query ran in by prefixing the query with SET TimeZone=;

SET TimeZone=UTC; GROUP BY Day(CreatedAt) { COUNT }

This method also allows for specifying the timezone when running queries from within the UI, which can be useful if you want to get consistent output from a saved query for all users, even if they are in different timezones.

If the timezone contains a space or punctuation character such as a forward slash, you will need to enclose it within double or single quotes e.g.

SET TimeZone="America/New_York"; GROUP BY Day(CreatedAt) { COUNT }

For more information on how SET (also known as query hints) work - see the SET topic in the TQL help section.

Browser Timezone identification

Enterprise Tester will automatically attempt to detect and use the timezone of the browser when performing searches from within the UI, this is done by using a 3rd party javascript library "jsTimezoneDetect".

If you find the results of your queries are incorrect due to mis-handling of timezone detection, currently your options are:

  • Notify us, and await a fix in the next version of Enterprise Tester.
  • Specify (via a "SET TimeZone=tz;" prefix on your query) the correct time zone to use.
  • Try changing the timezone of your machine to another timezone (with the same UTC offset) and see if that corrects the issue.

Timezone information for the server and client are displayed on the user-profile screen, under the "Timezone" heading, and hovering over the current time zone will display the "raw" IANA zone info key that is being passed to the Enterprise Tester server (which is then subsequently converted into a windows timezone when executing the TQL query.

Time Zone Identifiers

Enterprise Tester supports time zones specified using either the Windows Timezone ID or IANA zone info key (Olsen Timezone ID).

A list of common time zone identifiers follows:

  • Afghanistan Standard Time
  • Africa/Abidjan
  • Africa/Accra
  • Africa/Addis_Ababa
  • Africa/Algiers
  • Africa/Asmera
  • Africa/Bamako
  • Africa/Bangui
  • Africa/Banjul
  • Africa/Bissau
  • Africa/Blantyre
  • Africa/Brazzaville
  • Africa/Bujumbura
  • Africa/Cairo
  • Africa/Casablanca
  • Africa/Ceuta
  • Africa/Conakry
  • Africa/Dakar
  • Africa/DaresSalaam
  • Africa/Djibouti
  • Africa/Douala
  • Africa/El_Aaiun
  • Africa/Freetown
  • Africa/Gaborone
  • Africa/Harare
  • Africa/Johannesburg
  • Africa/Juba
  • Africa/Kampala
  • Africa/Khartoum
  • Africa/Kigali
  • Africa/Kinshasa
  • Africa/Lagos
  • Africa/Libreville
  • Africa/Lome
  • Africa/Luanda
  • Africa/Lubumbashi
  • Africa/Lusaka
  • Africa/Malabo
  • Africa/Maputo
  • Africa/Maseru
  • Africa/Mbabane
  • Africa/Mogadishu
  • Africa/Monrovia
  • Africa/Nairobi
  • Africa/Ndjamena
  • Africa/Niamey
  • Africa/Nouakchott
  • Africa/Ouagadougou
  • Africa/Porto-Novo
  • Africa/Sao_Tome
  • Africa/Tripoli
  • Africa/Tunis
  • Africa/Windhoek
  • Alaskan Standard Time
  • America/Anchorage
  • America/Anguilla
  • America/Antigua
  • America/Araguaina
  • America/Argentina/La_Rioja
  • America/Argentina/Rio_Gallegos
  • America/Argentina/Salta
  • America/Argentina/San_Juan
  • America/Argentina/San_Luis
  • America/Argentina/Tucuman
  • America/Argentina/Ushuaia
  • America/Aruba
  • America/Asuncion
  • America/Bahia
  • America/Bahia_Banderas
  • America/Barbados
  • America/Belem
  • America/Belize
  • America/Blanc-Sablon
  • America/Boa_Vista
  • America/Bogota
  • America/Boise
  • America/Buenos_Aires
  • America/Cambridge_Bay
  • America/Campo_Grande
  • America/Cancun
  • America/Caracas
  • America/Catamarca
  • America/Cayenne
  • America/Cayman
  • America/Chicago
  • America/Chihuahua
  • America/Coral_Harbour
  • America/Cordoba
  • America/Costa_Rica
  • America/Creston
  • America/Cuiaba
  • America/Curacao
  • America/Danmarkshavn
  • America/Dawson
  • America/Dawson_Creek
  • America/Denver
  • America/Detroit
  • America/Dominica
  • America/Edmonton
  • America/Eirunepe
  • America/El_Salvador
  • America/Fortaleza
  • America/Glace_Bay
  • America/Godthab
  • America/Goose_Bay
  • America/Grand_Turk
  • America/Grenada
  • America/Guadeloupe
  • America/Guatemala
  • America/Guayaquil
  • America/Guyana
  • America/Halifax
  • America/Hermosillo
  • America/Indiana/Knox
  • America/Indiana/Marengo
  • America/Indiana/Petersburg
  • America/Indiana/Tell_City
  • America/Indiana/Vevay
  • America/Indiana/Vincennes
  • America/Indiana/Winamac
  • America/Indianapolis
  • America/Inuvik
  • America/Iqaluit
  • America/Jamaica
  • America/Jujuy
  • America/Juneau
  • America/Kentucky/Monticello
  • America/Kralendijk
  • America/La_Paz
  • America/Lima
  • America/Los_Angeles
  • America/Louisville
  • America/Lower_Princes
  • America/Maceio
  • America/Managua
  • America/Manaus
  • America/Marigot
  • America/Martinique
  • America/Matamoros
  • America/Mazatlan
  • America/Mendoza
  • America/Menominee
  • America/Merida
  • America/Mexico_City
  • America/Moncton
  • America/Monterrey
  • America/Montevideo
  • America/Montreal
  • America/Montserrat
  • America/Nassau
  • America/New_York
  • America/Nipigon
  • America/Nome
  • America/Noronha
  • America/North_Dakota/Beulah
  • America/North_Dakota/Center
  • America/NorthDakota/NewSalem
  • America/Ojinaga
  • America/Panama
  • America/Pangnirtung
  • America/Paramaribo
  • America/Phoenix
  • America/PortofSpain
  • America/Port-au-Prince
  • America/Porto_Velho
  • America/Puerto_Rico
  • America/Rainy_River
  • America/Rankin_Inlet
  • America/Recife
  • America/Regina
  • America/Resolute
  • America/Rio_Branco
  • America/Santa_Isabel
  • America/Santarem
  • America/Santiago
  • America/Santo_Domingo
  • America/Sao_Paulo
  • America/Scoresbysund
  • America/Shiprock
  • America/Sitka
  • America/St_Barthelemy
  • America/St_Johns
  • America/St_Kitts
  • America/St_Lucia
  • America/St_Thomas
  • America/St_Vincent
  • America/Swift_Current
  • America/Tegucigalpa
  • America/Thule
  • America/Thunder_Bay
  • America/Tijuana
  • America/Toronto
  • America/Tortola
  • America/Vancouver
  • America/Whitehorse
  • America/Winnipeg
  • America/Yakutat
  • America/Yellowknife
  • Antarctica/Casey
  • Antarctica/Davis
  • Antarctica/DumontDUrville
  • Antarctica/Macquarie
  • Antarctica/Mawson
  • Antarctica/McMurdo
  • Antarctica/Palmer
  • Antarctica/Rothera
  • Antarctica/South_Pole
  • Antarctica/Syowa
  • Antarctica/Vostok
  • Arab Standard Time
  • Arabian Standard Time
  • Arabic Standard Time
  • Arctic/Longyearbyen
  • Argentina Standard Time
  • Asia/Aden
  • Asia/Almaty
  • Asia/Amman
  • Asia/Anadyr
  • Asia/Aqtau
  • Asia/Aqtobe
  • Asia/Ashgabat
  • Asia/Baghdad
  • Asia/Bahrain
  • Asia/Baku
  • Asia/Bangkok
  • Asia/Beirut
  • Asia/Bishkek
  • Asia/Brunei
  • Asia/Calcutta
  • Asia/Choibalsan
  • Asia/Chongqing
  • Asia/Colombo
  • Asia/Damascus
  • Asia/Dhaka
  • Asia/Dili
  • Asia/Dubai
  • Asia/Dushanbe
  • Asia/Gaza
  • Asia/Harbin
  • Asia/Hebron
  • Asia/Hong_Kong
  • Asia/Hovd
  • Asia/Irkutsk
  • Asia/Jakarta
  • Asia/Jayapura
  • Asia/Jerusalem
  • Asia/Kabul
  • Asia/Kamchatka
  • Asia/Karachi
  • Asia/Kashgar
  • Asia/Katmandu
  • Asia/Khandyga
  • Asia/Krasnoyarsk
  • Asia/Kuala_Lumpur
  • Asia/Kuching
  • Asia/Kuwait
  • Asia/Macau
  • Asia/Magadan
  • Asia/Makassar
  • Asia/Manila
  • Asia/Muscat
  • Asia/Nicosia
  • Asia/Novokuznetsk
  • Asia/Novosibirsk
  • Asia/Omsk
  • Asia/Oral
  • Asia/Phnom_Penh
  • Asia/Pontianak
  • Asia/Pyongyang
  • Asia/Qatar
  • Asia/Qyzylorda
  • Asia/Rangoon
  • Asia/Riyadh
  • Asia/Saigon
  • Asia/Sakhalin
  • Asia/Samarkand
  • Asia/Seoul
  • Asia/Shanghai
  • Asia/Singapore
  • Asia/Taipei
  • Asia/Tashkent
  • Asia/Tbilisi
  • Asia/Tehran
  • Asia/Thimphu
  • Asia/Tokyo
  • Asia/Ulaanbaatar
  • Asia/Urumqi
  • Asia/Ust-Nera
  • Asia/Vientiane
  • Asia/Vladivostok
  • Asia/Yakutsk
  • Asia/Yekaterinburg
  • Asia/Yerevan
  • Atlantic Standard Time
  • Atlantic/Azores
  • Atlantic/Bermuda
  • Atlantic/Canary
  • Atlantic/Cape_Verde
  • Atlantic/Faeroe
  • Atlantic/Madeira
  • Atlantic/Reykjavik
  • Atlantic/South_Georgia
  • Atlantic/St_Helena
  • Atlantic/Stanley
  • AUS Central Standard Time
  • AUS Eastern Standard Time
  • Australia/Adelaide
  • Australia/Brisbane
  • Australia/Broken_Hill
  • Australia/Currie
  • Australia/Darwin
  • Australia/Hobart
  • Australia/Lindeman
  • Australia/Melbourne
  • Australia/Perth
  • Australia/Sydney
  • Azerbaijan Standard Time
  • Azores Standard Time
  • Bahia Standard Time
  • Bangladesh Standard Time
  • Canada Central Standard Time
  • Cape Verde Standard Time
  • Caucasus Standard Time
  • Cen. Australia Standard Time
  • Central America Standard Time
  • Central Asia Standard Time
  • Central Brazilian Standard Time
  • Central Europe Standard Time
  • Central European Standard Time
  • Central Pacific Standard Time
  • Central Standard Time
  • Central Standard Time (Mexico)
  • China Standard Time
  • CST6CDT
  • Dateline Standard Time
  • E. Africa Standard Time
  • E. Australia Standard Time
  • E. Europe Standard Time
  • E. South America Standard Time
  • Eastern Standard Time
  • Egypt Standard Time
  • Ekaterinburg Standard Time
  • EST5EDT
  • Etc/GMT
  • Etc/GMT+1
  • Etc/GMT+10
  • Etc/GMT+11
  • Etc/GMT+12
  • Etc/GMT+2
  • Etc/GMT+3
  • Etc/GMT+4
  • Etc/GMT+5
  • Etc/GMT+6
  • Etc/GMT+7
  • Etc/GMT-1
  • Etc/GMT-10
  • Etc/GMT-11
  • Etc/GMT-12
  • Etc/GMT-13
  • Etc/GMT-2
  • Etc/GMT-3
  • Etc/GMT-4
  • Etc/GMT-5
  • Etc/GMT-6
  • Etc/GMT-7
  • Etc/GMT-8
  • Etc/GMT-9
  • Europe/Amsterdam
  • Europe/Andorra
  • Europe/Athens
  • Europe/Belgrade
  • Europe/Berlin
  • Europe/Bratislava
  • Europe/Brussels
  • Europe/Bucharest
  • Europe/Budapest
  • Europe/Busingen
  • Europe/Chisinau
  • Europe/Copenhagen
  • Europe/Dublin
  • Europe/Gibraltar
  • Europe/Guernsey
  • Europe/Helsinki
  • Europe/IsleofMan
  • Europe/Istanbul
  • Europe/Jersey
  • Europe/Kaliningrad
  • Europe/Kiev
  • Europe/Lisbon
  • Europe/Ljubljana
  • Europe/London
  • Europe/Luxembourg
  • Europe/Madrid
  • Europe/Malta
  • Europe/Mariehamn
  • Europe/Minsk
  • Europe/Monaco
  • Europe/Moscow
  • Europe/Oslo
  • Europe/Paris
  • Europe/Podgorica
  • Europe/Prague
  • Europe/Riga
  • Europe/Rome
  • Europe/Samara
  • Europe/San_Marino
  • Europe/Sarajevo
  • Europe/Simferopol
  • Europe/Skopje
  • Europe/Sofia
  • Europe/Stockholm
  • Europe/Tallinn
  • Europe/Tirane
  • Europe/Uzhgorod
  • Europe/Vaduz
  • Europe/Vatican
  • Europe/Vienna
  • Europe/Vilnius
  • Europe/Volgograd
  • Europe/Warsaw
  • Europe/Zagreb
  • Europe/Zaporozhye
  • Europe/Zurich
  • Fiji Standard Time
  • FLE Standard Time
  • Georgian Standard Time
  • GMT Standard Time
  • Greenland Standard Time
  • Greenwich Standard Time
  • GTB Standard Time
  • Hawaiian Standard Time
  • India Standard Time
  • Indian/Antananarivo
  • Indian/Chagos
  • Indian/Christmas
  • Indian/Cocos
  • Indian/Comoro
  • Indian/Kerguelen
  • Indian/Mahe
  • Indian/Maldives
  • Indian/Mauritius
  • Indian/Mayotte
  • Indian/Reunion
  • Iran Standard Time
  • Israel Standard Time
  • Jordan Standard Time
  • Kaliningrad Standard Time
  • Kamchatka Standard Time
  • Korea Standard Time
  • Magadan Standard Time
  • Mauritius Standard Time
  • Mid-Atlantic Standard Time
  • Middle East Standard Time
  • Montevideo Standard Time
  • Morocco Standard Time
  • Mountain Standard Time
  • Mountain Standard Time (Mexico)
  • MST7MDT
  • Myanmar Standard Time
  • N. Central Asia Standard Time
  • Namibia Standard Time
  • Nepal Standard Time
  • New Zealand Standard Time
  • Newfoundland Standard Time
  • North Asia East Standard Time
  • North Asia Standard Time
  • Pacific SA Standard Time
  • Pacific Standard Time
  • Pacific Standard Time (Mexico)
  • Pacific/Apia
  • Pacific/Auckland
  • Pacific/Efate
  • Pacific/Enderbury
  • Pacific/Fakaofo
  • Pacific/Fiji
  • Pacific/Funafuti
  • Pacific/Galapagos
  • Pacific/Guadalcanal
  • Pacific/Guam
  • Pacific/Honolulu
  • Pacific/Johnston
  • Pacific/Kosrae
  • Pacific/Kwajalein
  • Pacific/Majuro
  • Pacific/Midway
  • Pacific/Nauru
  • Pacific/Niue
  • Pacific/Noumea
  • Pacific/Pago_Pago
  • Pacific/Palau
  • Pacific/Ponape
  • Pacific/Port_Moresby
  • Pacific/Rarotonga
  • Pacific/Saipan
  • Pacific/Tahiti
  • Pacific/Tarawa
  • Pacific/Tongatapu
  • Pacific/Truk
  • Pacific/Wake
  • Pacific/Wallis
  • Pakistan Standard Time
  • Paraguay Standard Time
  • PST8PDT
  • Romance Standard Time
  • Russian Standard Time
  • SA Eastern Standard Time
  • SA Pacific Standard Time
  • SA Western Standard Time
  • Samoa Standard Time
  • SE Asia Standard Time
  • Singapore Standard Time
  • South Africa Standard Time
  • Sri Lanka Standard Time
  • Syria Standard Time
  • Taipei Standard Time
  • Tasmania Standard Time
  • Tokyo Standard Time
  • Tonga Standard Time
  • Turkey Standard Time
  • Ulaanbaatar Standard Time
  • US Eastern Standard Time
  • US Mountain Standard Time
  • UTC
  • UTC+12
  • UTC-02
  • UTC-11
  • Venezuela Standard Time
  • Vladivostok Standard Time
  • W. Australia Standard Time
  • W. Central Africa Standard Time
  • W. Europe Standard Time
  • West Asia Standard Time
  • West Pacific Standard Time
  • Yakutsk Standard Time

If your timezone is not present on this list, please let us know and we will add support for it in a future version of Enterprise Tester.

  • No labels