Snippet Name: TIMESTAMP: TZ_OFFSET
Description: The tz_offset function returns the time zone offset of a value.
'timezone' can be a valid time zone name, a time zone offset from UTC, the sessiontimezone function, or the dbtimezone function.
Also see: » FUNCTIONS: date/time
» TIMESTAMP: TRUNC
» TIMESTAMP: SysTimeStamp
» TIMESTAMP: SYS_EXTRACT_UTC
» TIMESTAMP: SessionTimeZone
» TIMESTAMP: LocalTimestamp
» TIMESTAMP: FROM_TZ
» TIMESTAMP: EXTRACT
» TIMESTAMP: DUMP
» TIMESTAMP: DBTIMEZONE
» TIMESTAMP: Get current timestamp
» TIMESTAMP: List time zones
Comment: (none)
Language: PL/SQL
Highlight Mode: PHP
Last Modified: March 04th, 2009
|
tz_offset( timezone )
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)
/*
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
*/ |