Home / Database / Oracle Application Express Documentation, Release 18.2
Application Express API Reference
Contents
Oracle Application Express Documentation, Release 18.2
Page 660 of 721

35.131 SET_SESSION_TIME_ZONE Procedure

This procedure sets the time zone to be used for the current user in the current Application Express session.

Syntax

APEX_UTIL.SET_SESSION_TIME_ZONE(
    p_time_zone IN VARCHAR2);

Parameters

Table 35-111 SET_SESSION_TIME_ZONE 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 Application Express session.

BEGIN
    APEX_UTIL.SET_SESSION_TIME_ZONE( P_TIME_ZONE => '-05:00');
END;
Previous Page
Page 660 of 721
Next Page