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.

Views

This node has no views

Workflows

• [01] F1 - Download DataKNIME Hub
• Date & time operationsKNIME Hub
• DuckDB Get Data From S3 (S3 Inventory File)KNIME Hub
• everdrop_case_2KNIME Hub
• everdrop_case_2KNIME Hub
• Show all 11 workflows

Links

• No links available

Developers