SET_SESSION_TIME_ZONE Procedure

58.137 SET_SESSION_TIME_ZONE Procedure

This procedure sets the time zone to be used for the current user in the current Oracle APEX session.

Syntax

APEX_UTIL.SET_SESSION_TIME_ZONE (
    p_time_zone IN VARCHAR2 );

Parameters

Parameter	Description
`p_timezone`	A time zone value in the form of hours and minutes. Examples include: `+09:00`, `04:00`, `-05:00`.

Example

The following example shows how to use the SET_SESSION_TIME_ZONE procedure. It sets the time zone for the current user for the duration of the APEX session.

BEGIN
    APEX_UTIL.SET_SESSION_TIME_ZONE( P_TIME_ZONE => '-05:00');
END;

Parent topic: APEX_UTIL