When an imported value has an additional time zone offset (e.g. +06:00) then such value:
- First, converted to UTC (+00:00):
e.g. 2022-05-01T00:00:00.000+06:00 = 2022-04-30T18:00:00.000+00:00 - Next, treated as local time at the time zone selected during import:
e.g. 2022-04-30T18:00:00.000 (selected time zone)
Notice that there is no conversion from UTC to the selected time zone, but an adjustment of the time zone itself).