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.

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:

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