Imports with additional time offset

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.

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.