TZCONVERTOR
The TZCONVERTOR function offsets a timestamp from one time zone to another time zone.
Syntax
TZCONVERTOR (TIMESTAMP <timestamp>, <source_zone>, <target_zone>)
Remarks
• The timestamp argument is in the form yyyy-mm-dd hh:mm:ss, enclosed in single-quotes.
• The source_zone argument is a string designating the source time zone, enclosed in single-quotes.
• The target_zone argument is a string designating the target time zone, enclosed in single-quotes.
• The TDV implementation of TZCONVERTOR does not support offset notation such as GMT+5.
• Valid source_zone / target_zone arguments are listed in
Time Zones.
Example (Date Is Outside of Daylight Saving Time Range)
TZCONVERTOR (TIMESTAMP '2011-3-1 00:00:00', 'US/Pacific', 'UTC')
OR
TZCONVERTOR (TIMESTAMP '2011-3-1 00:00:00', 'America/Los_Angeles', 'UTC')
Because daylight saving time is not in effect on the specified date, this example returns:
TIMESTAMP '2011-3-1 08:00:00'
Example (Date Is Inside the Daylight Saving Time Range)
TZCONVERTOR (TIMESTAMP '2011-9-1 00:00:00', 'US/Pacific', 'UTC')
OR
TZCONVERTOR (TIMESTAMP '2011-9-1 00:00:00', 'America/Los_Angeles', 'UTC')
Because daylight saving time is in effect on the specified summer date, this example returns:
TIMESTAMP '2011-9-1 07:00:00'