Oracle - PL/SQL - FROM_TZ Function

FROM_TZ converts a timestamp value and a time zone to a TIMESTAMP WITH TIME ZONE value. time_zone_value is a character string in the format 'TZH:TZM' or a character expression that returns a string in TZR with optional TZD format.

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 9i, Oracle 10g, Oracle 11g

For example:

If you executed the following SQL statement:

select from_tz(TIMESTAMP '2005-02-14 01:50:42', '5:00')
from dual;

You would now get the following result:

14-Feb-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-02-14 01:50:42', '-7:00')
from dual;

You would now get the following result:

14-Feb-05 01.50.42.000000 AM -07:00