Oracle PL/SQL: TIMESTAMP: SessionTimeZone - The sessiontimezone function returns the current session's time zone as a time zone offset (in the f

Quick Search:

Oracle PL/SQL: TIMESTAMP: SessionTimeZone

Jump to:

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

<< last

next >>

Snippet Name: TIMESTAMP: SessionTimeZone

Description: The sessiontimezone function returns the current session's time zone as a time zone offset (in the following format: '[+|-]TZH:TZM') or a time zone region name.

Also see:
» FUNCTIONS: date/time
» TIMESTAMP: TZ_OFFSET
» TIMESTAMP: TRUNC
» TIMESTAMP: SysTimeStamp
» TIMESTAMP: SYS_EXTRACT_UTC
» 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: PLSQL
Last Modified: March 04th, 2009

SESSIONTIMEZONE
 
 
SELECT SESSIONTIMEZONE
FROM dual;
 
-- The sessiontimezone function might return a value like this:
 
    +00:00
 
-- or a value such as this:
 
    -07:00
 
-- The value returned depends on how the user specified the 
-- session time zone value in the most recent ALTER SESSION 
-- statement. 
 
SELECT SESSIONTIMEZONE, CURRENT_TIMESTAMP FROM dual;
 
ALTER SESSION SET TIME_ZONE = '-9:00';
 
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';
 
SELECT SESSIONTIMEZONE, CURRENT_TIMESTAMP FROM dual;
 
ALTER SESSION SET time_zone = local;