FROM_TZ(x, time_zone) converts the TIMESTAMP x and time zone specified by time_zone to a TIMESTAMP WITH TIMEZONE. : FROM_TZ « Date Timestamp Functions « Oracle PL/SQL Tutorial
13. 7. 1. FROM_TZ(x, time_zone) converts the TIMESTAMP x and time zone specified by time_zone to a TIMESTAMP WITH TIMEZONE.
SQL>
SQL> SELECT FROM_TZ(TIMESTAMP '2005-05-13 07:15:31.1234', 'EST')
2 FROM dual;
FROM_TZ(TIMESTAMP'2005-05-1307:15:31.1234','EST')
---------------------------------------------------------------------------
13-MAY-05 07.15.31.123400000 AM EST
SQL>
13. 7. FROM_TZ
13. 7. 1.
FROM_TZ(x, time_zone) converts the TIMESTAMP x and time zone specified by time_zone to a TIMESTAMP WITH TIMEZONE.