Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL TIMEZONE_REGION Keyword      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: TIMEZONE_REGION

Definition:
In Oracle PL/SQL, the TIMEZONE_REGION keyword refers to the named region that corresponds to a specific time zone. The following regions are the accepted values in the Oracle database:

The timezones region are listed in groups, grouped by their standard offsets from GMT. Note that 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



Related Links:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 48 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?