Find time zones for a given UTC offset: : timezone_names « System Tables Views « Oracle PL / SQL






Find time zones for a given UTC offset:

 
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> --

 








Related examples in the same category