Mega Code Archive
Find time zones for a given UTC offset
<![CDATA[
SQL>
SQL> select tzname, tzabbrev
2 from v$timezone_names
3 where substr( tz_offset(tzname), 1,6) = '-06:00';
TZNAME
----------------------------------------------------------------
TZABBREV
----------------------------------------------------------------
America/Boise
LMT
America/Boise
PST
America/Boise
PWT
America/Boise
MST
America/Boise
MWT
America/Boise
MDT
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/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/Denver
LMT
America/Denver
MST
America/Denver
MWT
America/Denver
MDT
America/Edmonton
LMT
America/Edmonton
MST
America/Edmonton
MDT
America/El_Salvador
LMT
America/El_Salvador
CST
America/El_Salvador
CDT
America/Guatemala
LMT
America/Guatemala
CST
America/Guatemala
CDT
America/Inuvik
LMT
America/Inuvik
PST
America/Inuvik
PDT
America/Inuvik
PDDT
America/Inuvik
MST
America/Inuvik
MDT
America/Managua
LMT
America/Managua
MMT
America/Managua
CST
America/Managua
EST
America/Managua
CDT
America/Mazatlan
LMT
America/Mazatlan
MST
America/Mazatlan
CST
America/Mazatlan
PST
America/Mazatlan
MDT
America/Regina
LMT
America/Regina
MST
America/Regina
MDT
America/Regina
CST
America/Shiprock
LMT
America/Shiprock
MST
America/Shiprock
MWT
America/Shiprock
MDT
America/Swift_Current
LMT
America/Swift_Current
MST
America/Swift_Current
MDT
America/Swift_Current
CST
America/Tegucigalpa
LMT
America/Tegucigalpa
CST
America/Tegucigalpa
CDT
America/Yellowknife
LMT
America/Yellowknife
MST
America/Yellowknife
MDT
America/Yellowknife
MDDT
Canada/East-Saskatchewan
LMT
Canada/East-Saskatchewan
MST
Canada/East-Saskatchewan
MDT
Canada/East-Saskatchewan
CST
Canada/Mountain
LMT
Canada/Mountain
MST
Canada/Mountain
MDT
Canada/Saskatchewan
LMT
Canada/Saskatchewan
MST
Canada/Saskatchewan
MDT
Canada/Saskatchewan
CST
Chile/EasterIsland
LMT
Chile/EasterIsland
MMT
Chile/EasterIsland
EAST
Chile/EasterIsland
EASST
Etc/GMT+6
GMT+6
Mexico/BajaSur
LMT
Mexico/BajaSur
MST
Mexico/BajaSur
CST
Mexico/BajaSur
PST
Mexico/BajaSur
MDT
MST
LMT
MST
MST
MST
MWT
MST
MDT
MST7MDT
LMT
MST7MDT
MST
MST7MDT
MWT
MST7MDT
MDT
Navajo
LMT
Navajo
MST
Navajo
MWT
Navajo
MDT
Pacific/Easter
LMT
Pacific/Easter
MMT
Pacific/Easter
EAST
Pacific/Easter
EASST
US/Mountain
LMT
US/Mountain
MST
US/Mountain
MWT
US/Mountain
MDT
111 rows selected.
SQL>
SQL> --
]]>