Adjusts an Oracle DATE value from one time zone region to another.
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);
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 regions overlap period. Its ignored if date_var falls outside the from_tz time zone regions 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 thats 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.