The FROM_TZ function combines a TIMSTAMP value with the time zone information into a time value of the TIMESTAMP WITH TIME ZONE data type.
Syntax
FROM_TZ (timestamp_value,time_zone_value)
Parameters
| Parameter | Description |
|---|---|
| timestamp_value | A time value of the TIMSTAMP data type. |
| time_zone_value | The time zone information. |
Return type
TIMESTAMP WITH TIME ZONE data type
Examples
Execute the following statement:
SELECT FROM_TZ(TIMESTAMP '2020-03-28 08:00:00', '-03:00') FROM DUAL;
The following query result is returned:
+------------------------------------------------+
| FROM_TZ(TIMESTAMP'2020-03-2808:00:00','-03:00') |
+------------------------------------------------+
| 2020-03-28 08:00:00.000000000 -03:00 |
+------------------------------------------------+