Oracle SESSIONTIMEZONE function

How to get the time zone of the current session in Oracle?

The SESSIONTIMEZONE function is used to get the time zone of the current session.

Syntax:

SESSIONTIMEZONE

Parameters :

No parameters.

Return Type:

The return type is a time zone offset or a time zone region name, depending on how the user specified the session time zone value in the most recent ALTER SESSION statement.

Applies to:
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i

Pictorial Presentation

Example: Oracle SESSIONTIMEZONE function

The following example returns the time zone of the current session:

SELECT SESSIONTIMEZONE FROM DUAL;

Sample Output:

SESSION
-------
+05:30

Previous: ROUND(date)
Next: SYS_EXTRACT_UTC