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'