Oracle/PLSQL: From_Tz function

In Oracle/PLSQL, the from_tz function converts a TIMESTAMP value (given a TIME ZONE) to a TIMESTAMP WITH TIME ZONE value.

Syntax

The syntax for the from_tz function is:

from_tz( timestamp_value, time_zone_value )

timestamp_value is the value to convert to a TIMESTAMP WITH TIME ZONE value.

time_zone_value is the time zone used to convert timestamp_value to a TIMESTAMP WITH TIME ZONE value.

Applies To

• Oracle 11g, Oracle 10g, Oracle 9i

For Example

If you executed the following SQL statement:

select from_tz(TIMESTAMP '2005-09-11 01:50:42', '5:00')

from dual;

You would now get the following result:

11-Sep-05 01.50.42.000000 AM +05:00

If you executed the same SQL statement, but set the time zone to '-7:00' as follows:

select from_tz(TIMESTAMP '2005-09-11 01:50:42', '-7:00')

from dual;

You would now get the following result:

11-Sep-05 01.50.42.000000 AM -07:00