EXAMPLE - Time Zone Conversion Functions

This example shows how you can use the following functions to convert Datetime values to different time zones.

• CONVERTFROMUTC - Converts valid Datetime values from UTC time zone to a specified time zone. See CONVERTFROMUTC Function.
• CONVERTTOUTC - Converts valid Datetime values from a specified time zone to UTC time zone. See CONVERTTOUTC Function.
• CONVERTTIMEZONE - Converts valid Datetime values from one time zone to another. See CONVERTTIMEZONE Function.

Source:

Transformation: 

When you import the above dates,  Designer Cloud Enterprise Edition may not recognize the column as a set of dates. You can use the column menus to format the date values to the following standardized format:

yyyy*mm*dd*HH:MM:SS

When the type has been changed, row 1 and row 3 have been identified as invalid. You can use the following transformation to remove these rows:

When the Datetime values are consistently formatted, you can use the following transformations to perform conversions. The following tranformation converts the values from UTC to US/Eastern time zone:

This transformation now assumes that the date values are in US/Pacific time zone and converts them to UTC:

The final transformation converts the date time values between arbitrary time zones. In this case, the values are assumed to be in US/Alaska time zone and are converted to US/Hawaii time zone:

Results: