Convert to UTC time zone

<< Click to Display Table of Contents >>

Navigation:  How do I? >

Convert to UTC time zone

If you have a column of datetimes and a column of time zone hour adjustments, you can convert them to UTC (Coordinated Universal Time) 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 using the DateTimeToUTC operation in the Calculate transform:

 

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

 

See also:

Video: How to convert datetimes to UTC time zone