This is an old revision of the document!
Returns the date and time adjusted to time_zone2. The function is helpful when trying to show a time stored in the a standard like Greenish Mean Time (GMT) to a local time.
The return datatype is ORACLE DATETIME.
This function is only available when the CREATE ENVIRONMENT statement contains the SQL_SYNTAX ORACLE clause or the SET SQL_SYNTAX ORACLE setting is set programmatically.
NEW_TIME(datetime, from_timezone, to_timezone)
datetime is a Oracle datetime column or string.
from_timezone is a string literal representing an Oracle timezone.
from_timezone is a string literal representing an Oracle timezone.