This function returns the time zone for the current user in the current Oracle APEX session. This value is null if the time zone is not explicitly set by using APEX_UTIL.SET_SESSION_TIME_ZONE or if an application's automatic time zone attribute is enabled.

Syntax

APEX_UTIL.GET_SESSION_TIME_ZONE
RETURN VARCHAR2;

Parameters

None.

Example

The following example returns the session time zone for the current user in the current APEX session into a local variable.

DECLARE
    VAL VARCHAR2(255);
BEGIN
    VAL := apex_util.get_session_time_zone;
END;