Oracle SESSIONTIMEZONE Function

Oracle SESSIONTIMEZONE FunctionOracle SESSIONTIMEZONE Function is used to get current session’s time zone as a time zone offset or even as a time zone region name.


Oracle SESSIONTIMEZONE Function Syntax

 SELECT SESSIONTIMEZONE
FROM table_name;

Oracle SESSIONTIMEZONE – Using SQL SELECT Statement Example

Oracle SESSIONTIMEZONE Function is used with the SQL SELECT Statement.

For example, the Oracle SESSIONTIMEZONE query below returns the current session’s time zone.

SELECT SESSIONTIMEZONE
FROM DUAL;

May return “-07:00”
Or it may return “:+5:30”
Depending upon the latest session time zone value as set by the ALTER SESSION command.


Tagged , , , , , , , , , , , . Bookmark the permalink.