.. _auto_database_timezone_converter:

*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
------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20 20 20

   * - 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
-------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20

   * - 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

.. raw:: html

   <hr style="margin-top:2em">
   <p style="font-size:11px;color:#888">
   Auto-generated from <code>platform</code> schema. Worker id: <code>database_timezone_converter</code>. Schema hash: <code>ba16e45cfb28</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>