Quick Search:
 
 Oracle PL/SQL: TIMESTAMP: List time zones Jump to:  
Category: >> Oracle PL/SQL >> TIMESTAMP: List time zones  

<< lastnext >>

Snippet Name: TIMESTAMP: List time zones

Description: Produces a list of valid timezones.

Also see:
» FUNCTIONS: date/time
» TIMESTAMP: TZ_OFFSET
» 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

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 04th, 2009 

SET linesize 121
col tzname format a30
col tzabbrev format a30
 
SELECT *
FROM gv$timezone_names;
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org