Term: FROM_TZ

Definition:
The Oracle PL/SQL FROM_TZ function is a built in function that provides conversion of a timestamp to TIMESTAMP WITH TIME ZONE for a given timezone. Essentially it combines the timestamp and timezone information into a single operation

Example Syntax:

FROM_TZ (timestamp, timezone) RETURN TIMESTAMP WITH TIME ZONE

timezone is a string in the format 'TZH:TZM'.
timezone is the time zone used to convert the timestamp to a TIMESTAMP WITH TIME ZONE value.

Example usage:

SELECT FROM_TZ (TIMESTAMP '2010-11-01 10:00:00', '3:00') FROM DUAL;



FROM_TZ(TIMESTAMP '2010-11-0110:00:00','3:00')

------------------------------------------------------------------

01-NOV-10 10.00.00 AM +03:00

Related Links:

Oracle Timestamp Functions: FROM_TZ

Related Code Snippets:

TIMESTAMP: FROM_TZ - The from_tz function converts a TIMESTAMP value (given a TIME ZONE) to a TIME...