A script-enabled browser is required for this page to function properly.

ADJUST_TZ Built-in

Description

Adjusts an Oracle DATE value from one time zone region to another.

Syntax

PROCEDURE ADJUST_TZ
(date_var IN OUT DATE,
from_tz VARCHAR2,
to_tz VARCHAR2);

PROCEDURE ADJUST_TZ
(date_var IN OUT DATE,
from_tz VARCHAR2,
to_tz VARCHAR2,
is_daylight IN OUT BOOLEAN,
is_in_overlap OUT BOOLEAN,
timezone_label OUT VARCHAR2);

Parameters

date_var is adjusted from the from_tz time zone region to the to_tz time zone region. date_var can be a Forms DATE or DATETIME item, or a Forms DATE parameter, or a local PL/SQL DATE variable.

Three additional parameters provide extra feedback as to where the date falls in the to_tz time zone region.

is_daylight indicates whether the date is in daylight saving time. The is_daylight parameter is also used as an input parameter, to disambiguate dates that fall within the from_tz time zone region’s overlap period. It’s ignored if date_var falls outside the from_tz time zone region’s overlap period. If omitted, is_daylight defaults to FALSE.

is_in_overlap indicates whether the date falls within the "overlap period" (the ambiguous 2-hour period that occurs once a year when switching from daylight saving time back to standard time).

timezone_label is a label for daylight versus standard that’s appropriate for the to_tz time zone region. For example, when the to_tz time zone region is US/Pacific, timezone_label will be set to PST when is_daylight is set to FALSE, and to PDT when is_daylight is set to TRUE.


Datetime_Server_TZ Property

Datetime_Local_TZ Property

FORMS_TZFILE

About DATETIME Items