Oracle/PLSQL: Tz_Offset Function
In Oracle/PLSQL, the tz_offset function returns the time zone offset of a value.
The syntax for the tz_offset function is:
tz_offset( timezone )
timezone can be a valid time zone name, a time zone offset from UTC, the sessiontimezone function, or the dbtimezone function.
Some of the more commonly used time zone names are:
Canada/Atlantic Pacific/Easter Canada/Central Pacific/Honolulu Canada/East-Saskatchewan Pacific/Kwajalein Canada/Eastern Pacific/Pago_Pago Canada/Mountain Pacific/Samoa Canada/Newfoundland US/Alaska Canada/Pacific US/Aleutian Canada/Saskatchewan US/Arizona Canada/Yukon US/Central Europe/Dublin US/East-Indiana Europe/Istanbul US/Eastern Europe/Lisbon US/Hawaii Europe/London US/Michigan Europe/Moscow US/Mountain Europe/Warsaw US/Pacific Greenwich US/Pacific-New Pacific/Auckland US/Samoa Pacific/Chatham
To find more time zone values, you can run the following query:
select distinct tzname
from V$TIMEZONE_NAMES;
Applies To:
- Oracle 9i, Oracle 10g, Oracle 11g
For Example:
tz_offset('US/Michigan') would return '-05:00' tz_offset('-08:00') would return '-08:00' tz_offset(sessiontimezone) would return '-07:00' (depending on your configuration) tz_offset(dbtimezone) would return '-07:00' (depending on your configuration)