CONV_TIMESTAMP

Use the CONV_TIMESTAMP script function to convert a date and time to a different time zone. For more information, see Time Zone (TZ). The script function returns the timestamp in the YYYY-MM-DD HH:MM:SS format .

Syntax

CONV_TIMESTAMP (Timestamp,[TimeZone1][,TimeZone2])

Parameters

CONV_TIMESTAMP
Converts date and time for use in another time zone
Timestamp
Timestamp from date and time in YYYY-MM-DD HH:MM:SS format
Format: script literal or script variable
TimeZone1
(Optional) Name of a TimeZone object or keyword UTC.
The time zone assigned to a timestamp or UTC. It defines the original time zone on which the calculation should be based.
Format: script literal or script variable
Default: UTC
TimeZone2
(Optional) Name of a TimeZone object.
Time zone for which the timestamp is to be converted.
Format: script literal or script variable
Default: The time zone that is defined for the object. If the object does not include a time zone definition, the time zone of the client is used.

Important! If you do not use UTC as the basis for calculation, conversion results are imprecise when you change from Daylight Savings Time to Standard Time. Example: The system cannot identify whether the time 02:30:00 refers to its first occurrence in Daylight Savings Time, or to its second occurrence in Standard Time. Therefore, the system reads it as its first occurrence. For details, see Daylight Saving and Standard Time Changes.

Example

You have two Time Zone objects: one for Sydney, Austria (TZ.SYD), and another for Central European time (TZ.CET). The following script converts the timestamp for the turn of the year 2017/2018.

:SET &CET# = CONV_TIMESTAMP("2018-01-01 00:00:00","TZ.SYD","TZ.CET")

:PRINT &CET#

Line in the activation report:

2019-03-28 10:17:59 - U00020408 2017-12-31 14:00:00