Mega Code Archive
Obtaining Time Zone Names
<![CDATA[
SQL>
SQL> --You can obtain all the time zone names by selecting all the rows from v$timezone_names.
SQL>
SQL> SELECT * FROM v$timezone_names where rownum < 200;
TZNAME TZABBREV
---------------------------------------------------------------- ----------------------------------------------------------------
Africa/Algiers LMT
Africa/Algiers PMT
Africa/Algiers WET
Africa/Algiers WEST
Africa/Algiers CET
Africa/Algiers CEST
Africa/Cairo LMT
Africa/Cairo EET
Africa/Cairo EEST
Africa/Casablanca LMT
Africa/Casablanca WET
Africa/Casablanca WEST
Africa/Casablanca CET
Africa/Ceuta LMT
Africa/Ceuta WET
Africa/Ceuta WEST
Africa/Ceuta CET
Africa/Ceuta CEST
Africa/Djibouti LMT
Africa/Djibouti EAT
Africa/Freetown LMT
Africa/Freetown FMT
Africa/Freetown WAT
Africa/Freetown SLST
Africa/Freetown GMT
Africa/Johannesburg LMT
Africa/Johannesburg SAST
Africa/Khartoum LMT
Africa/Khartoum CAT
Africa/Khartoum CAST
Africa/Mogadishu LMT
Africa/Mogadishu EAT
Africa/Mogadishu BEAT
Africa/Nairobi LMT
Africa/Nairobi EAT
Africa/Nairobi BEAT
Africa/Nairobi BEAUT
Africa/Nouakchott LMT
Africa/Nouakchott GMT
Africa/Nouakchott WAT
Africa/Tripoli LMT
Africa/Tripoli CET
Africa/Tripoli CEST
Africa/Tripoli EET
Africa/Tunis LMT
Africa/Tunis PMT
Africa/Tunis CET
Africa/Tunis CEST
Africa/Windhoek LMT
Africa/Windhoek SWAT
Africa/Windhoek SAST
Africa/Windhoek CAT
Africa/Windhoek WAT
Africa/Windhoek WAST
America/Adak LMT
America/Adak NST
America/Adak NWT
America/Adak BST
America/Adak BDT
America/Adak HAST
America/Adak HADT
America/Anchorage LMT
America/Anchorage CAT
America/Anchorage CAWT
America/Anchorage AHST
America/Anchorage AHDT
America/Anchorage AKST
America/Anchorage AKDT
America/Anguilla LMT
America/Anguilla AST
America/Araguaina LMT
America/Araguaina BRT
America/Araguaina BRST
America/Aruba LMT
America/Aruba ANT
America/Aruba AST
America/Asuncion LMT
America/Asuncion AMT
America/Asuncion PYT
America/Asuncion PYST
America/Atka LMT
America/Atka NST
America/Atka NWT
America/Atka BST
America/Atka BDT
America/Atka HAST
America/Atka HADT
America/Belem LMT
America/Belem BRT
America/Belem BRST
America/Boa_Vista LMT
America/Boa_Vista AMT
America/Boa_Vista AMST
America/Bogota LMT
America/Bogota BMT
America/Bogota COT
America/Bogota COST
America/Boise LMT
America/Boise PST
America/Boise PWT
America/Boise MST
America/Boise MWT
America/Boise MDT
America/Buenos_Aires LMT
America/Buenos_Aires CMT
America/Buenos_Aires ART
America/Buenos_Aires ARST
America/Cambridge_Bay LMT
America/Cambridge_Bay MST
America/Cambridge_Bay MDT
America/Cambridge_Bay MDDT
America/Cambridge_Bay CST
America/Cambridge_Bay CDT
America/Cambridge_Bay EST
America/Cancun LMT
America/Cancun CST
America/Cancun EST
America/Cancun EDT
America/Cancun CDT
America/Caracas LMT
America/Caracas CMT
America/Caracas VET
America/Cayenne LMT
America/Cayenne GFT
America/Cayman LMT
America/Cayman KMT
America/Cayman EST
America/Chicago LMT
America/Chicago CST
America/Chicago CWT
America/Chicago CDT
America/Chicago EST
America/Chihuahua LMT
America/Chihuahua MST
America/Chihuahua CST
America/Chihuahua CDT
America/Chihuahua MDT
America/Costa_Rica LMT
America/Costa_Rica SJMT
America/Costa_Rica CST
America/Costa_Rica CDT
America/Cuiaba LMT
America/Cuiaba AMT
America/Cuiaba AMST
America/Curacao LMT
America/Curacao ANT
America/Curacao AST
America/Dawson LMT
America/Dawson YST
America/Dawson YDT
America/Dawson YDDT
America/Dawson PST
America/Dawson PDT
America/Dawson_Creek LMT
America/Dawson_Creek PST
America/Dawson_Creek PDT
America/Dawson_Creek MST
America/Denver LMT
America/Denver MST
America/Denver MWT
America/Denver MDT
America/Detroit LMT
America/Detroit CST
America/Detroit EST
America/Detroit EWT
America/Detroit EDT
America/Edmonton LMT
America/Edmonton MST
America/Edmonton MDT
America/El_Salvador LMT
America/El_Salvador CST
America/El_Salvador CDT
America/Ensenada LMT
America/Ensenada MST
America/Ensenada PST
America/Ensenada PDT
America/Ensenada PWT
TZNAME TZABBREV
---------------------------------------------------------------- ----------------------------------------------------------------
America/Fort_Wayne LMT
America/Fort_Wayne CST
America/Fort_Wayne CWT
America/Fort_Wayne CDT
America/Fort_Wayne EST
America/Fort_Wayne EDT
America/Fortaleza LMT
America/Fortaleza BRT
America/Fortaleza BRST
America/Godthab LMT
America/Godthab WGT
America/Godthab WGST
America/Goose_Bay LMT
America/Goose_Bay NST
America/Goose_Bay NDT
America/Goose_Bay AST
America/Goose_Bay ADT
America/Goose_Bay ADDT
America/Grand_Turk LMT
America/Grand_Turk KMT
America/Grand_Turk EST
America/Grand_Turk EDT
199 rows selected.
SQL>
]]>