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:
Related Code Snippets:
- TIMESTAMP: FROM_TZ - The from_tz function converts a TIMESTAMP value (given a TIME ZONE) to a TIME...
