Convert time zone

<< Click to Display Table of Contents >>

Navigation:  How do I? >

Convert time zone

If you have a column of datetimes and a column of time zone hour adjustments, you can convert them to a standard time zone using the DateTimeAddHours operation in the Calculate transform:

 

How to adjust a column of datetimes to standardize the timezone.

 

If you have a column of datetimes with UTC offsets, you can convert them to UTC (Coordinated Universal Time) using the DateTimeToUTC operation in the Calculate transform:

 

How to convert ISO datetimes with UTC offset to UTC (Universal Coordinated Time/Zulu time, GMT).