Obtaining Time Zone Names
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>