Oracle 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.