All Products
Search
Document Center

FROM_TZ

Last Updated: Jun 18, 2021

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           |
+------------------------------------------------+