iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

Oracle Tips/Questions and Answers:

 

More Resources by Google:

 

The following is a list of all timezone you need to have:  --How to change Agent Time Zone
replica6-replica:<$AGENT_HOME/sysman/admin> $more supportedtzs.lst
#
# The following is the list of Timezone supported by the EM agent.
# This is same as the list of timezones supported by 10g Oracle database.
#
# The timezones region are listed in groups, grouped by their standard offsets from GMT.
# Within each group, the timezone region names are listed alphabetically.

# Timezone regions with +00:00 standard offset from GMT
Africa/Casablanca
Africa/Freetown
Africa/Nouakchott
Atlantic/Canary
Atlantic/Faeroe
Atlantic/Madeira
Atlantic/Reykjavik
Atlantic/St_Helena
Eire
Etc/GMT
Etc/GMT+0
Etc/GMT-0
Etc/GMT0
Etc/Greenwich
Europe/Belfast
Europe/Dublin
Europe/Lisbon
Europe/London
GB
GB-Eire
GMT
GMT+0
GMT-0
GMT0
Greenwich
Iceland
Portugal
UTC
WET

# Timezone regions with +01:00 standard offset from GMT
Africa/Algiers
Africa/Ceuta
Africa/Tunis
Arctic/Longyearbyen
CET
Etc/GMT-1
Europe/Amsterdam
Europe/Belgrade
Europe/Berlin
Europe/Bratislava
Europe/Brussels
Europe/Budapest
Europe/Copenhagen
Europe/Gibraltar
Europe/Ljubljana
Europe/Luxembourg
Europe/Madrid
Europe/Monaco
Europe/Oslo
Europe/Paris
Europe/Prague
Europe/Rome
Europe/San_Marino
Europe/Sarajevo
Europe/Skopje
Europe/Stockholm
Europe/Tirane
Europe/Vatican
Europe/Vienna
Europe/Warsaw
Europe/Zagreb
Europe/Zurich
MET
Poland

# Timezone regions with +02:00 standard offset from GMT
Africa/Cairo
Africa/Johannesburg
Africa/Khartoum
Africa/Tripoli
Africa/Windhoek
Asia/Beirut
Asia/Damascus
Asia/Gaza
Asia/Istanbul
Asia/Jerusalem
Asia/Nicosia
Asia/Tel_Aviv
EET
Egypt
Etc/GMT-2
Europe/Athens
Europe/Bucharest
Europe/Helsinki
Europe/Istanbul
Europe/Kaliningrad
Europe/Kiev
Europe/Minsk
Europe/Riga
Europe/Simferopol
Europe/Sofia
Europe/Tallinn
Europe/Vilnius
Israel
Libya
Turkey

# Timezone regions with +03:00 standard offset from GMT
Africa/Djibouti
Africa/Mogadishu
Africa/Nairobi
Asia/Aden
Asia/Amman
Asia/Baghdad
Asia/Bahrain
Asia/Kuwait
Asia/Qatar
Asia/Riyadh
Etc/GMT-3
Europe/Moscow
Indian/Mayotte
W-SU

# Timezone regions with +03:30 standard offset from GMT
Asia/Tehran
Iran

# Timezone regions with +04:00 standard offset from GMT
Asia/Aqtau
Asia/Baku
Asia/Dubai
Asia/Muscat
Asia/Tbilisi
Asia/Yerevan
Etc/GMT-4
Europe/Samara
Indian/Reunion

# Timezone regions with +04:30 standard offset from GMT
Asia/Kabul

# Timezone regions with +05:00 standard offset from GMT
Asia/Aqtobe
Asia/Bishkek
Asia/Karachi
Asia/Tashkent
Asia/Yekaterinburg
Etc/GMT-5
Indian/Chagos

# Timezone regions with +05:30 standard offset from GMT
Asia/Calcutta

# Timezone regions with +06:00 standard offset from GMT
Asia/Almaty
Asia/Dacca
Asia/Novosibirsk
Asia/Omsk
Etc/GMT-6

# Timezone regions with +06:30 standard offset from GMT
Asia/Rangoon
Indian/Cocos

# Timezone regions with +07:00 standard offset from GMT
Asia/Bangkok
Asia/Jakarta
Asia/Krasnoyarsk
Asia/Saigon
Etc/GMT-7
Indian/Christmas

# Timezone regions with +08:00 standard offset from GMT
Asia/Chungking
Asia/Harbin
Asia/Hong_Kong
Asia/Irkutsk
Asia/Kashgar
Asia/Kuala_Lumpur
Asia/Kuching
Asia/Macao
Asia/Manila
Asia/Shanghai
Asia/Singapore
Asia/Taipei
Asia/Ujung_Pandang
Asia/Urumqi
Australia/Perth
Australia/West
Etc/GMT-8
Hongkong
PRC
ROC
Singapore

# Timezone regions with +09:00 standard offset from GMT
Asia/Jayapura
Asia/Seoul
Asia/Tokyo
Asia/Yakutsk
Etc/GMT-9
Japan
ROK

# Timezone regions with +09:30 standard offset from GMT
Australia/Darwin
Australia/North

# Timezone regions with +10:00 standard offset from GMT
Asia/Vladivostok
Australia/Brisbane
Australia/Lindeman
Australia/Queensland
Etc/GMT-10
Pacific/Guam
Pacific/Saipan

# Timezone regions with +10:30 standard offset from GMT
Australia/Adelaide
Australia/Broken_Hill
Australia/South
Australia/Yancowinna

# Timezone regions with +11:00 standard offset from GMT
Asia/Magadan
Australia/ACT
Australia/Canberra
Australia/Hobart
Australia/LHI
Australia/Lord_Howe
Australia/Melbourne
Australia/NSW
Australia/Sydney
Australia/Tasmania
Australia/Victoria
Etc/GMT-11
Pacific/Noumea

# Timezone regions with +11:30 standard offset from GMT
Pacific/Norfolk

# Timezone regions with +12:00 standard offset from GMT
Asia/Kamchatka
Etc/GMT-12
Kwajalein
Pacific/Kwajalein
Pacific/Wake
Pacific/Wallis

# Timezone regions with +13:00 standard offset from GMT
Asia/Anadyr
Etc/GMT-13
NZ
Pacific/Auckland
Pacific/Fiji

# Timezone regions with +13:45 standard offset from GMT
NZ-CHAT
Pacific/Chatham

# Timezone regions with -01:00 standard offset from GMT
America/Scoresbysund
Atlantic/Azores
Etc/GMT+1

# Timezone regions with -02:00 standard offset from GMT
America/Araguaina
America/Fortaleza
America/Maceio
America/Noronha
America/Sao_Paulo
Brazil/DeNoronha
Brazil/East
Etc/GMT+2

# Timezone regions with -03:00 standard offset from GMT
America/Asuncion
America/Belem
America/Boa_Vista
America/Buenos_Aires
America/Cayenne
America/Cuiaba
America/Godthab
America/Miquelon
America/Montevideo
America/Santiago
Atlantic/Stanley
Chile/Continental
Etc/GMT+3

# Timezone regions with -03:30 standard offset from GMT
America/St_Johns
Canada/Newfoundland

# Timezone regions with -04:00 standard offset from GMT
America/Anguilla
America/Caracas
America/Curacao
America/Goose_Bay
America/Guadeloupe
America/Halifax
America/La_Paz
America/Manaus
America/Martinique
America/Montserrat
America/Porto_Velho
America/Puerto_Rico
America/St_Thomas
America/Thule
America/Tortola
America/Virgin
Atlantic/Bermuda
Brazil/West
Canada/Atlantic
Etc/GMT+4

# Timezone regions with -05:00 standard offset from GMT
America/Bogota
America/Cayman
America/Detroit
America/Fort_Wayne
America/Grand_Turk
America/Guayaquil
America/Havana
America/Indianapolis
America/Indiana/Indianapolis
America/Indiana/Knox
America/Indiana/Marengo
America/Indiana/Vevay
America/Jamaica
America/Knox_IN
America/Lima
America/Louisville
America/Montreal
America/New_York
America/Panama
America/Thunder_Bay
America/Porto_Acre
Brazil/Acre
Canada/Eastern
Chile/EasterIsland
Cuba
EST
EST5EDT
Etc/GMT+5
Jamaica
Pacific/Easter
US/East-Indiana
US/Eastern
US/Indiana-Starke
US/Michigan

# Timezone regions with -06:00 standard offset from GMT
America/Cambridge_Bay
America/Cancun
America/Chicago
America/Costa_Rica
America/El_Salvador
America/Guatemala
America/Iqaluit
America/Managua
America/Mexico_City
America/Rankin_Inlet
America/Regina
America/Swift_Current
America/Tegucigalpa
America/Winnipeg
CST
CST6CDT
Canada/Central
Canada/East-Saskatchewan
Canada/Saskatchewan
Etc/GMT+6
Mexico/General
US/Central

# Timezone regions with -07:00 standard offset from GMT
America/Boise
America/Chihuahua
America/Dawson_Creek
America/Denver
America/Edmonton
America/Inuvik
America/Mazatlan
America/Phoenix
America/Shiprock
America/Yellowknife
Canada/Mountain
Etc/GMT+7
MST
MST7MDT
Mexico/BajaSur
Navajo
US/Arizona
US/Mountain

# Timezone regions with -08:00 standard offset from GMT
America/Dawson
America/Ensenada
America/Los_Angeles
America/Tijuana
America/Vancouver
America/Whitehorse
Canada/Pacific
Canada/Yukon
Etc/GMT+8
Mexico/BajaNorte
PST
PST8PDT
US/Pacific
US/Pacific-New

# Timezone regions with -08:30 standard offset from GMT
Pacific/Pitcairn

# Timezone regions with -09:00 standard offset from GMT
America/Anchorage
America/Juneau
America/Nome
Etc/GMT+9
Pacific/Gambier
US/Alaska

# Timezone regions with -09:30 standard offset from GMT
Pacific/Marquesas

# Timezone regions with -10:00 standard offset from GMT
America/Adak
America/Atka
Etc/GMT+10
HST
Pacific/Fakaofo
Pacific/Honolulu
Pacific/Johnston
Pacific/Rarotonga
Pacific/Tahiti
US/Aleutian
US/Hawaii

# Timezone regions with -11:00 standard offset from GMT
Etc/GMT+11
Pacific/Midway
Pacific/Niue
Pacific/Pago_Pago
Pacific/Samoa
US/Samoa

# Timezone regions with -12:00 standard offset from GMT
# -12:00 Offset from GMT
Etc/GMT+12


Good Luck!

 

Google
 
Web web site