Date
Timezone Convert
Converts date-times from one time zone to another — UTC server logs to Berlin time, say — writing the result as YYYY-MM-DD HH:mm:ss.
When to use it
Use it when timestamps are stored in UTC (or another zone) but reports, filters or deadlines must use local time.
In a pipeline
File InputTimezone ConvertExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Column | select | Yes | Select column… |
| From time zone | text | — | UTC |
| To time zone | text | Yes | IANA name, e.g. Europe/Berlin |
Example
UTC logs to Berlin time
- Column=At
- From time zone=UTC
- To time zone=Europe/Berlin
| Event | At |
|---|---|
| login | 2026-10-15T08:00:00Z |
| export | 2026-12-01 23:30:00 |
| Event | At |
|---|---|
| login | 2026-10-15 10:00:00 |
| export | 2026-12-02 00:30:00 |
Berlin is two hours ahead in October (summer time) and one hour ahead in December — daylight saving is handled for you.
Worth knowing
- Time zones are IANA names: Europe/Berlin, America/New_York, Asia/Shanghai, UTC.
- Values that already carry a zone (ending in Z or +02:00), Unix timestamps and spreadsheet dates are exact moments, so the From zone does not apply to them; plain clock readings are taken to be in the From zone.
- To keep the original column, copy it first (e.g. with Calculated Column) and convert the copy.