In Oracle/PLSQL, the tz_offset function returns the time zone offset of a value.
Syntax
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 11g, Oracle 10g, Oracle 9i
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) |
590
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
