Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: TIMESTAMP: TZ_OFFSET Jump to:  
Category: >> Oracle PL/SQL >> TIMESTAMP: TZ_OFFSET Bookmark and Share

<< lastnext >>

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


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 191 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?