---
title: "Imports with additional time offset"
slug: "imports-with-additional-time-offset"
updated: 2026-01-02T16:05:50Z
published: 2026-01-02T16:05:50Z
canonical: "docs.mapp.com/imports-with-additional-time-offset"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.mapp.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](/v1/docs/mapp-engage-clusters-and-time-zones).

**Example 1**

| Import time | 2022-05-01T00:00:00.000+06:00 (Daylight Saving Time) |
| --- | --- |
| Selected time zone | Europe/London |
| Outcome | 2022-04-30T19:00:00.000+02:00 |

**Example 2**

| Import time | 2022-05-01T00:00:00.000+06:00 (Daylight Saving Time) |
| --- | --- |
| Selected time zone | Europe/Berlin (the same as the EU cluster) |
| Outcome | 2022-04-30T20:00:00.000+02:00 |

**Example 3**

| Import time | 2022-05-01T00:00:00.000+06:00 (Daylight Saving Time) |
| --- | --- |
| Selected time zone | Asia/Shanghai |
| Outcome | 2022-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](/v1/docs/mapp-engage-clusters-and-time-zones).

**Example 1**

| Import time | 2022-05-01T00:00:00.000+06:00 (Daylight Saving Time) |
| --- | --- |
| Selected time zone | Europe/London |
| Outcome | 2022-04-30T19:00:00.000+02:00 |

**Example 2**

| Import time | 2022-05-01T00:00:00.000+06:00 (Daylight Saving Time) |
| --- | --- |
| **Selected time zone** | US/Eastern (the same as the US cluster) |
| Outcome | 2022-04-30T20:00:00.000+02:00 |

**Example 3**

| Import time | 2022-05-01T00:00:00.000+06:00 (Daylight Saving Time) |
| --- | --- |
| **Selected time zone** | Asia/Shanghai |
| Outcome | 2022-04-30T12:00:00.000+02:00 |