Where is Applications Manager's Timezone list stored?

book

Article ID: 185937

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Where is Applications Manager's Timezone list stored?

Environment

Component : APPLICATIONS MANAGER

Resolution

Applications Manager's Timezone list is stored in the table AW_TIMEZONE_LIST. For reference, below is a the timezone list from Applications Manager version 9.3.1 with Oracle 18C. Timezone list and values may differ depending on application and Oracle version.

AW_GMT_DIFF = Time difference to Greenwich Mean Time (GMT 0)
AW_TZ_NAME = Timezone Name
AW_USE_DLS = Whether Timezone adheres (Y) or does not adhere (N) to Daylight Savings
AW_DLS_DIFF = When adhering to Daylight Savings, the hour value shifted during Daylight Savings


AW_GMT_DIFF AW_TZ_NAME AW_USE_DLS AW_DLS_DIFF
-12 Etc/GMT+12 N 0
-11 Etc/GMT+11 N 0
-11 Pacific/Midway N 0
-11 Pacific/Niue N 0
-11 Pacific/Pago_Pago N 0
-11 Pacific/Samoa N 0
-11 US/Samoa N 0
-10 America/Adak Y 1
-10 America/Atka Y 1
-10 Etc/GMT+10 N 0
-10 HST N 0
-10 Pacific/Fakaofo N 0
-10 Pacific/Honolulu N 0
-10 Pacific/Johnston N 0
-10 Pacific/Rarotonga N 0
-10 Pacific/Tahiti N 0
-10 US/Aleutian Y 1
-10 US/Hawaii N 0
-9 Pacific/Marquesas N 0
-9 America/Anchorage Y 1
-9 America/Juneau Y 1
-9 America/Nome Y 1
-9 America/Yakutat Y 1
-9 Etc/GMT+9 N 0
-9 Pacific/Gambier N 0
-9 US/Alaska Y 1
-8 America/Dawson Y 1
-8 America/Ensenada Y 1
-8 America/Los_Angeles Y 1
-8 America/Tijuana Y 1
-8 America/Vancouver Y 1
-8 America/Whitehorse Y 1
-8 Canada/Pacific Y 1
-8 Canada/Yukon Y 1
-8 Etc/GMT+8 N 0
-8 Mexico/BajaNorte Y 1
-8 PST Y 1
-8 PST8PDT Y 1
-8 Pacific/Pitcairn N 0
-8 US/Pacific Y 1
-8 US/Pacific-New Y 1
-7 America/Boise Y 1
-7 America/Cambridge_Bay Y 1
-7 America/Chihuahua Y 1
-7 America/Dawson_Creek N 0
-7 America/Denver Y 1
-7 America/Edmonton Y 1
-7 America/Hermosillo N 0
-7 America/Inuvik Y 1
-7 America/Mazatlan Y 1
-7 America/Phoenix N 0
-7 America/Shiprock Y 1
-7 America/Yellowknife Y 1
-7 Canada/Mountain Y 1
-7 Etc/GMT+7 N 0
-7 MST Y 1
-7 MST7MDT Y 1
-7 Mexico/BajaSur Y 1
-7 Navajo Y 1
-7 US/Arizona N 0
-7 US/Mountain Y 1
-6 America/Belize N 0
-6 America/Cancun Y 1
-6 America/Chicago Y 1
-6 America/Costa_Rica N 0
-6 America/El_Salvador N 0
-6 America/Guatemala N 0
-6 America/Indiana/Knox Y 1
-6 America/Indiana/Tell_City Y 1
-6 America/Knox_IN Y 1
-6 America/Managua N 0
-6 America/Menominee Y 1
-6 America/Merida Y 1
-6 America/Mexico_City Y 1
-6 America/Monterrey Y 1
-6 America/North_Dakota/Center Y 1
-6 America/North_Dakota/New_Salem Y 1
-6 America/Rainy_River Y 1
-6 America/Rankin_Inlet Y 1
-6 America/Regina N 0
-6 America/Swift_Current N 0
-6 America/Tegucigalpa N 0
-6 America/Winnipeg Y 1
-6 CST Y 1
-6 CST6CDT Y 1
-6 Canada/Central Y 1
-6 Canada/East-Saskatchewan N 0
-6 Canada/Saskatchewan N 0
-6 Chile/EasterIsland Y 1
-6 Etc/GMT+6 N 0
-6 Mexico/General Y 1
-6 Pacific/Easter Y 1
-6 Pacific/Galapagos N 0
-6 US/Central Y 1
-6 US/Indiana-Starke Y 1
-6 America/Resolute Y 1
-6 America/Bahia_Banderas Y 1
-5 America/Atikokan N 0
-5 America/Bogota N 0
-5 America/Cayman Y 1
-5 America/Coral_Harbour N 0
-5 America/Detroit Y 1
-5 America/Fort_Wayne Y 1
-5 America/Grand_Turk Y 1
-5 America/Guayaquil N 0
-5 America/Havana Y 1
-5 America/Indiana/Indianapolis Y 1
-5 America/Indiana/Marengo Y 1
-5 America/Indiana/Petersburg Y 1
-5 America/Indiana/Vevay Y 1
-5 America/Indiana/Vincennes Y 1
-5 America/Indiana/Winamac Y 1
-5 America/Indianapolis Y 1
-5 America/Iqaluit Y 1
-5 America/Jamaica N 0
-5 America/Kentucky/Louisville Y 1
-5 America/Kentucky/Monticello Y 1
-5 America/Lima N 0
-5 America/Louisville Y 1
-5 America/Montreal Y 1
-5 America/Nassau Y 1
-5 America/New_York Y 1
-5 America/Nipigon Y 1
-5 America/Panama N 0
-5 America/Pangnirtung Y 1
-5 America/Port-au-Prince Y 1
-5 America/Thunder_Bay Y 1
-5 America/Toronto Y 1
-5 Canada/Eastern Y 1
-5 Cuba Y 1
-5 EST Y 1
-5 EST5EDT Y 1
-5 Etc/GMT+5 N 0
-5 Jamaica N 0
-5 US/East-Indiana Y 1
-5 US/Eastern Y 1
-5 US/Michigan Y 1
-4.5 America/Caracas N 0
-4 America/Anguilla N 0
-4 America/Antigua N 0
-4 America/Argentina/San_Luis Y 1
-4 America/Aruba N 0
-4 America/Asuncion Y 1
-4 America/Barbados N 0
-4 America/Blanc-Sablon N 0
-4 America/Boa_Vista N 0
-4 America/Campo_Grande Y 1
-4 America/Cuiaba Y 1
-4 America/Curacao N 0
-4 America/Dominica N 0
-4 America/Eirunepe N 0
-4 America/Glace_Bay Y 1
-4 America/Goose_Bay Y 1
-4 America/Grenada N 0
-4 America/Guadeloupe N 0
-4 America/Guyana N 0
-4 America/Halifax Y 1
-4 America/La_Paz N 0
-4 America/Manaus N 0
-4 America/Marigot N 0
-4 America/Martinique N 0
-4 America/Moncton Y 1
-4 America/Montserrat N 0
-4 America/Port_of_Spain N 0
-4 America/Porto_Acre N 0
-4 America/Porto_Velho N 0
-4 America/Puerto_Rico N 0
-4 America/Rio_Branco N 0
-4 America/Santiago Y 1
-4 America/Santo_Domingo N 0
-4 America/St_Barthelemy N 0
-4 America/St_Kitts N 0
-4 America/St_Lucia N 0
-4 America/St_Thomas N 0
-4 America/St_Vincent N 0
-4 America/Thule Y 1
-4 America/Tortola N 0
-4 America/Virgin N 0
-4 Antarctica/Palmer Y 1
-4 Atlantic/Bermuda Y 1
-4 Atlantic/Stanley Y 1
-4 Brazil/Acre N 0
-4 Brazil/West N 0
-4 Canada/Atlantic Y 1
-4 Chile/Continental Y 1
-4 Etc/GMT+4 N 0
-3.5 America/St_Johns Y 1
-3.5 Canada/Newfoundland Y 1
-3 America/Araguaina N 0
-3 America/Argentina/Buenos_Aires Y 1
-3 America/Argentina/Catamarca N 0
-3 America/Argentina/ComodRivadavia N 0
-3 America/Argentina/Cordoba Y 1
-3 America/Argentina/Jujuy N 0
-3 America/Argentina/La_Rioja N 0
-3 America/Argentina/Mendoza N 0
-3 America/Argentina/Rio_Gallegos N 0
-3 America/Argentina/Salta N 0
-3 America/Argentina/San_Juan N 0
-3 America/Argentina/Tucuman Y 1
-3 America/Argentina/Ushuaia N 0
-3 America/Bahia N 0
-3 America/Belem N 0
-3 America/Buenos_Aires Y 1
-3 America/Catamarca N 0
-3 America/Cayenne N 0
-3 America/Cordoba Y 1
-3 America/Fortaleza N 0
-3 America/Godthab Y 1
-3 America/Jujuy N 0
-3 America/Maceio N 0
-3 America/Mendoza N 0
-3 America/Miquelon Y 1
-3 America/Montevideo Y 1
-3 America/Paramaribo N 0
-3 America/Recife N 0
-3 America/Rosario Y 1
-3 America/Sao_Paulo Y 1
-3 Brazil/East Y 1
-3 Etc/GMT+3 N 0
-2 America/Noronha N 0
-2 Atlantic/South_Georgia N 0
-2 Brazil/DeNoronha N 0
-2 Etc/GMT+2 N 0
-1 America/Scoresbysund Y 1
-1 Atlantic/Azores Y 1
-1 Atlantic/Cape_Verde N 0
-1 Etc/GMT+1 N 0
0 Africa/Abidjan N 0
0 Africa/Accra N 0
0 Africa/Bamako N 0
0 Africa/Banjul N 0
0 Africa/Bissau N 0
0 Africa/Casablanca Y 1
0 Africa/Conakry N 0
0 Africa/Dakar N 0
0 Africa/El_Aaiun Y 1
0 Africa/Freetown N 0
0 Africa/Lome N 0
0 Africa/Monrovia N 0
0 Africa/Nouakchott N 0
0 Africa/Ouagadougou N 0
0 Africa/Sao_Tome N 0
0 Africa/Timbuktu N 0
0 America/Danmarkshavn N 0
0 Atlantic/Canary Y 1
0 Atlantic/Faeroe Y 1
0 Atlantic/Faroe Y 1
0 Atlantic/Madeira Y 1
0 Atlantic/Reykjavik N 0
0 Atlantic/St_Helena N 0
0 Eire Y 1
0 Etc/GMT N 0
0 Etc/GMT+0 N 0
0 Etc/GMT-0 N 0
0 Etc/GMT0 N 0
0 Etc/Greenwich N 0
0 Europe/Belfast Y 1
0 Europe/Dublin Y 1
0 Europe/Guernsey Y 1
0 Europe/Isle_of_Man Y 1
0 Europe/Jersey Y 1
0 Europe/Lisbon Y 1
0 Europe/London Y 1
0 GB Y 1
0 GB-Eire Y 1
0 GMT N 0
0 GMT0 N 0
0 Greenwich N 0
0 Iceland N 0
0 Portugal Y 1
0 UTC N 0
0 WET Y 1
1 Africa/Algiers N 0
1 Africa/Bangui N 0
1 Africa/Brazzaville N 0
1 Africa/Ceuta Y 1
1 Africa/Douala N 0
1 Africa/Kinshasa N 0
1 Africa/Lagos N 0
1 Africa/Libreville N 0
1 Africa/Luanda N 0
1 Africa/Malabo N 0
1 Africa/Ndjamena N 0
1 Africa/Niamey N 0
1 Africa/Porto-Novo N 0
1 Africa/Tunis Y 1
1 Africa/Windhoek Y 1
1 Arctic/Longyearbyen Y 1
1 Atlantic/Jan_Mayen Y 1
1 CET Y 1
1 Etc/GMT-1 N 0
1 Europe/Amsterdam Y 1
1 Europe/Andorra Y 1
1 Europe/Belgrade Y 1
1 Europe/Berlin Y 1
1 Europe/Bratislava Y 1
1 Europe/Brussels Y 1
1 Europe/Budapest Y 1
1 Europe/Copenhagen Y 1
1 Europe/Gibraltar Y 1
1 Europe/Ljubljana Y 1
1 Europe/Luxembourg Y 1
1 Europe/Madrid Y 1
1 Europe/Malta Y 1
1 Europe/Monaco Y 1
1 Europe/Oslo Y 1
1 Europe/Paris Y 1
1 Europe/Podgorica Y 1
1 Europe/Prague Y 1
1 Europe/Rome Y 1
1 Europe/San_Marino Y 1
1 Europe/Sarajevo Y 1
1 Europe/Skopje Y 1
1 Europe/Stockholm Y 1
1 Europe/Tirane Y 1
1 Europe/Vaduz Y 1
1 Europe/Vatican Y 1
1 Europe/Vienna Y 1
1 Europe/Warsaw Y 1
1 Europe/Zagreb Y 1
1 Europe/Zurich Y 1
1 MET Y 1
1 Poland Y 1
2 Africa/Blantyre N 0
2 Africa/Bujumbura N 0
2 Africa/Cairo Y 1
2 Africa/Gaborone N 0
2 Africa/Harare N 0
2 Africa/Johannesburg N 0
2 Africa/Kigali N 0
2 Africa/Lubumbashi N 0
2 Africa/Lusaka N 0
2 Africa/Maputo N 0
2 Africa/Maseru N 0
2 Africa/Mbabane N 0
2 Africa/Tripoli N 0
2 Asia/Amman Y 1
2 Asia/Beirut Y 1
2 Asia/Damascus Y 1
2 Asia/Gaza Y 1
2 Asia/Istanbul Y 1
2 Asia/Jerusalem Y 1
2 Asia/Nicosia Y 1
2 Asia/Tel_Aviv Y 1
2 EET Y 1
2 Egypt Y 1
2 Etc/GMT-2 N 0
2 Europe/Athens Y 1
2 Europe/Bucharest Y 1
2 Europe/Chisinau Y 1
2 Europe/Helsinki Y 1
2 Europe/Istanbul Y 1
2 Europe/Kaliningrad Y 1
2 Europe/Kiev Y 1
2 Europe/Mariehamn Y 1
2 Europe/Minsk Y 1
2 Europe/Nicosia Y 1
2 Europe/Riga Y 1
2 Europe/Simferopol Y 1
2 Europe/Sofia Y 1
2 Europe/Tallinn Y 1
2 Europe/Tiraspol Y 1
2 Europe/Uzhgorod Y 1
2 Europe/Vilnius Y 1
2 Europe/Zaporozhye Y 1
2 Israel Y 1
2 Libya N 0
2 Turkey Y 1
3 Africa/Addis_Ababa N 0
3 Africa/Asmara N 0
3 Africa/Asmera N 0
3 Africa/Dar_es_Salaam N 0
3 Africa/Djibouti N 0
3 Africa/Kampala N 0
3 Africa/Khartoum N 0
3 Africa/Mogadishu N 0
3 Africa/Nairobi N 0
3 Antarctica/Syowa N 0
3 Asia/Aden N 0
3 Asia/Baghdad N 0
3 Asia/Bahrain N 0
3 Asia/Kuwait N 0
3 Asia/Qatar N 0
3 Asia/Riyadh N 0
3 Etc/GMT-3 N 0
3 Europe/Moscow Y 1
3 Europe/Volgograd Y 1
3 Indian/Antananarivo N 0
3 Indian/Comoro N 0
3 Indian/Mayotte N 0
3 W-SU Y 1
3.5 Asia/Tehran Y 1
3.5 Iran Y 1
4 Asia/Baku Y 1
4 Asia/Dubai N 0
4 Asia/Muscat N 0
4 Asia/Tbilisi N 0
4 Asia/Yerevan Y 1
4 Etc/GMT-4 N 0
4 Europe/Samara Y 1
4 Indian/Mahe N 0
4 Indian/Mauritius N 0
4 Indian/Reunion N 0
4 Asia/Kabul N 0
5 Asia/Aqtau N 0
5 Asia/Aqtobe N 0
5 Asia/Ashgabat N 0
5 Asia/Ashkhabad N 0
5 Asia/Dushanbe N 0
5 Asia/Karachi N 0
5 Asia/Oral N 0
5 Asia/Samarkand N 0
5 Asia/Tashkent N 0
5 Asia/Yekaterinburg Y 1
5 Etc/GMT-5 N 0
5 Indian/Kerguelen N 0
5 Indian/Maldives N 0
5.5 Asia/Calcutta N 0
5.5 Asia/Colombo N 0
5.5 Asia/Kolkata N 0
5.75 Asia/Kathmandu N 0
5.75 Asia/Katmandu N 0
6 Antarctica/Mawson N 0
6 Asia/Almaty N 0
6 Asia/Bishkek N 0
6 Asia/Dacca N 0
6 Asia/Dhaka N 0
6 Asia/Novosibirsk Y 1
6 Asia/Omsk Y 1
6 Asia/Qyzylorda N 0
6 Asia/Thimbu N 0
6 Asia/Thimphu N 0
6 Etc/GMT-6 N 0
6 Indian/Chagos N 0
6 Asia/Rangoon N 0
6 Indian/Cocos N 0
7 Antarctica/Davis N 0
7 Asia/Bangkok N 0
7 Asia/Ho_Chi_Minh N 0
7 Asia/Hovd Y 1
7 Asia/Jakarta N 0
7 Asia/Krasnoyarsk Y 1
7 Asia/Phnom_Penh N 0
7 Asia/Pontianak N 0
7 Asia/Saigon N 0
7 Asia/Vientiane N 0
7 Etc/GMT-7 N 0
7 Indian/Christmas N 0
8 Antarctica/Casey N 0
8 Asia/Brunei N 0
8 Asia/Choibalsan Y 1
8 Asia/Chongqing N 0
8 Asia/Chungking N 0
8 Asia/Harbin N 0
8 Asia/Hong_Kong N 0
8 Asia/Irkutsk Y 1
8 Asia/Kashgar N 0
8 Asia/Kuala_Lumpur N 0
8 Asia/Kuching N 0
8 Asia/Macao N 0
8 Asia/Macau N 0
8 Asia/Makassar N 0
8 Asia/Manila N 0
8 Asia/Shanghai N 0
8 Asia/Singapore N 0
8 Asia/Taipei N 0
8 Asia/Ujung_Pandang N 0
8 Asia/Ulaanbaatar Y 1
8 Asia/Ulan_Bator Y 1
8 Asia/Urumqi N 0
8 Australia/Perth N 0
8 Australia/West N 0
8 Etc/GMT-8 N 0
8 Hongkong N 0
8 PRC N 0
8 Singapore N 0
8 Australia/Eucla N 0
9 Asia/Dili N 0
9 Asia/Jayapura N 0
9 Asia/Pyongyang N 0
9 Asia/Seoul N 0
9 Asia/Tokyo N 0
9 Asia/Yakutsk Y 1
9 Etc/GMT-9 N 0
9 Japan N 0
9 Pacific/Palau N 0
9 ROK N 0
9 Australia/Darwin N 0
9 Australia/North N 0
9.5 Australia/Adelaide Y 1
9.5 Australia/Broken_Hill Y 1
9.5 Australia/South Y 1
9.5 Australia/Yancowinna Y 1
10 Antarctica/DumontDUrville N 0
10 Asia/Sakhalin Y 1
10 Asia/Vladivostok Y 1
10 Australia/ACT Y 1
10 Australia/Brisbane N 0
10 Australia/Canberra Y 1
10 Australia/Currie Y 1
10 Australia/Hobart Y 1
10 Australia/Lindeman N 0
10 Australia/Melbourne Y 1
10 Australia/NSW Y 1
10 Australia/Queensland N 0
10 Australia/Sydney Y 1
10 Australia/Tasmania Y 1
10 Australia/Victoria Y 1
10 Etc/GMT-10 N 0
10 Pacific/Guam N 0
10 Pacific/Port_Moresby N 0
10 Pacific/Saipan N 0
10 Pacific/Truk N 0
10 Pacific/Yap N 0
10.5 Australia/LHI Y 0.5
10.5 Australia/Lord_Howe Y 0.5
11 Asia/Magadan Y 1
11 Etc/GMT-11 N 0
11 Pacific/Efate N 0
11 Pacific/Guadalcanal N 0
11 Pacific/Kosrae N 0
11 Pacific/Noumea N 0
11 Pacific/Ponape N 0
11 Pacific/Norfolk N 0
12 Antarctica/McMurdo Y 1
12 Antarctica/South_Pole Y 1
12 Asia/Anadyr Y 1
12 Asia/Kamchatka Y 1
12 Etc/GMT-12 N 0
12 Kwajalein N 0
12 NZ Y 1
12 Pacific/Auckland Y 1
12 Pacific/Fiji Y 1
12 Pacific/Funafuti N 0
12 Pacific/Kwajalein N 0
12 Pacific/Majuro N 0
12 Pacific/Nauru N 0
12 Pacific/Tarawa N 0
12 Pacific/Wake N 0
12 Pacific/Wallis N 0
12.75 NZ-CHAT Y 1
12.75 Pacific/Chatham Y 1
13 Pacific/Apia Y 1
13 Etc/GMT-13 N 0
13 Pacific/Enderbury N 0
13 Pacific/Tongatapu N 0
14 Etc/GMT-14 N 0
14 Pacific/Kiritimati N 0