Time Zone Modifier

Modifies date&time columns by adding, changing, shifting, or removing time zone information. This node can add or change the time zone of date&time columns without adjusting the time values. It can also shift the time zone of zoned date&time columns and adjust the time and date according to the new time zone offset. Additionally, it can remove the time zone information from zoned date&time columns, converting them to local date&time columns.
Useful for standardizing time zones in datasets from different regions or preparing time-based data for analysis.

Options

Modification
Defines the action to be performed on the selected columns.
  • Set: Changes the time zone of a date&time column, leaving the wall time unchanged.
  • Shift: Changes the time zone of a date&time column, changing the wall time so it refers to the same instant. Both, the nominal date and time may change.
  • Remove: Removes time zone information from zoned date&time columns.
Time zone
The time zone to use when modifying the date&time.
Date&time columns
The date&time columns whose values to modify.
Output columns
Depending on this setting, the output columns will either replace the modified columns, or be appended to the table with a suffix.
  • Replace: Replaces the selected columns by the new columns.
  • Append with suffix: Appends the selected columns to the input table with a new name that is the previous name plus the provided suffix.
Output column suffix
The suffix to append to the column names of the new columns.

Input Ports

Icon
Input table containing date&time columns.

Output Ports

Icon
Output table with modified time zone.

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.