Oracle PL/SQL From_Tz Function

The From_Tz function converts a TIMESTAMP value (given a TIME ZONE) to a TIMESTAMP WITH TIME ZONE value.

The From_Tz Function syntax:

from_tz( timestamp_value, time_zone_value )

Example:

select from_tz(TIMESTAMP '2010-09-11 01:30:25', '6:00')from dual;
11-SEP-10 01.30.25.000000000 AM +06:00

select from_tz(TIMESTAMP '2010-09-11 01:30:25', '-9:00')from dual;
11-SEP-10 01.30.25.000000000 AM -09:00