how to use sessiontimezone function in oracle database query

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