Imports with additional time offset

Overview

This page explains how imported date-time values are stored when the incoming data has the format yyyy-mm-ddThh:mm:ss.sss and includes an additional time offset (for example, +03:00).

Time offset behavior

When an imported value includes an additional time zone offset (for example, +06:00), the value is handled in two steps:

1. The value is first converted to UTC (+00:00).

   • Example:
     2022-05-01T00:00:00.000+06:00 → 2022-04-30T18:00:00.000+00:00

2. The resulting UTC value is then treated as the local time in the time zone selected during import.

   • Example:
     2022-04-30T18:00:00.000 (selected time zone)

There is no conversion from UTC to the selected time zone. Instead, the time zone of the value itself is adjusted.

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.