Oracle PL/SQL: TIMESTAMP: TZ OFFSET - The tz offset function returns the time zone offset of a value. <br /> <br /> 'timezone' can be a

Quick Search:

Oracle PL/SQL: TIMESTAMP: TZ_OFFSET

Jump to:

Category: >> Oracle PL/SQL >> TIMESTAMP: TZ_OFFSET

<< last

next >>

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