TIMEZONE CONVERTER¶
Converts datetime values stored in database columns (those ending in _on) from a source timezone to a destination timezone across all tables. Use this worker when database records need to be migrated or normalised to a different timezone.
When to use¶
Tagged: conversion, database, datetime, migration, sql, timezone.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Source Tz | source_tz | text | — | IANA timezone string (e.g. ‘America/New_York’) representing the current timezone of datetime values stored in the database; required for the conversion to be performed. | |
| Duration | duration | text | — | Optional duration or time-window constraint to limit which records are processed; leave blank to process all matching records. |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| Slept | slept | integer | Integer count of records (rows) processed or updated during the timezone conversion run. |
Disciplines¶
- data.io.sql
- platform.integration
Auto-generated from platform schema. Worker id: database_timezone_converter. Schema hash: ba16e45cfb28. Hand-curated docs in workerexamples/ override this page when present.