Examples in this section describe outcomes where the imported data has the format yyyy-mm-ddThh:mm:ss.sss, and where there is an additional time offset (e.g. +03:00).

When an imported value has an additional time zone offset (e.g. +06:00) then such value:

  1. First, converted to UTC (+00:00):
    e.g. 2022-05-01T00:00:00.000+06:00 = 2022-04-30T18:00:00.000+00:00
  2. 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).

Examples

EU Cluster

The default EU cluster time zone is Europe/Berlin:

  • CEST: UTC+2 (Daylight Saving Time)
  • EST: UTC+1 (Standard Time)

For more information, see Mapp Engage Clusters and Time Zones.

 Example 1
Import time2022-05-01T00:00:00.000+06:00 (Daylight Saving Time)
Selected time zoneEurope/London
Outcome2022-04-30T19:00:00.000+02:00
 Example 2
Import time2022-05-01T00:00:00.000+06:00 (Daylight Saving Time)
Selected time zoneEurope/Berlin (the same as the EU cluster)
Outcome2022-04-30T20:00:00.000+02:00
 Example 3
Import time2022-05-01T00:00:00.000+06:00 (Daylight Saving Time)
Selected time zoneAsia/Shanghai
Outcome2022-04-30T12:00:00.000+02:00

US cluster

The default US cluster time zone is US/Eastern:

  • EST: UTC-5 (Standard Time)
  • EDT: UTC-4 (Daylight Saving Time)

For more information, see Mapp Engage Clusters and Time Zones.

 Example 1
Import time2022-05-01T00:00:00.000+06:00 (Daylight Saving Time)
Selected time zoneEurope/London
Outcome2022-04-30T19:00:00.000+02:00
 Example 2
Import time2022-05-01T00:00:00.000+06:00 (Daylight Saving Time)
Selected time zoneUS/Eastern (the same as the US cluster)
Outcome2022-04-30T20:00:00.000+02:00
 Example 3
Import time2022-05-01T00:00:00.000+06:00 (Daylight Saving Time)
Selected time zoneAsia/Shanghai
Outcome2022-04-30T12:00:00.000+02:00