FROM_TZ – Oracle SQL Function

FROM_TZ converts a timestamp and time zone value into a TIMESTAMP WITH TIMEZONE value.

Syntax:

FROM_TZ(timestamp, timezone)

Example:

SELECT FROM_TZ(TIMESTAMP ‘2004-10-24 06:00:00’, ‘2:00’) as RESULT FROM DUAL;

RESULT
————–
24-Oct-04 06.00.00 AM +2:00