w3resource

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

Pictorial Presentation of Oracle SESSIONTIMEZONE function

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



Share this Tutorial / Exercise on : Facebook and Twitter