![]() Previous |
![]() Next |
The FROM_TZ function converts a timestamp value and a time zone to a TIMESTAMP_TZ
value.
Return Values
TIMESTAMP_TZ
Syntax
FROM_TZ (timestamp_value , time_zone_value)
Parameters
A text expression with a TIMESTAMP data type.
A text expression that returns a string in the format TZH:TZM or in TZR with optional TZD format.
Examples
Creating a TIMESTAMP_TZ Value from a Timestamp Value and a Time Zone
DEFINE mytimestamp VARIABLE TIMESTAMP DEFINE mytimezone VARIABLE TEXT DEFINE mytimestamptz VARIABLE TIMESTAMP_TZ mytimestamp = '26-MAR-06' mytimezone = '-04:00' mytimestamptz = FROM_TZ (mytimestamp mytimezone) REPORT mytimestamptz MYTIMESTAMPTZ ------------------------------ 26-MAR-06 12.00.00 AM -04:00