Date Modifier

Modifies date&time columns by appending, changing, or removing the date component. You can append a date to time columns (output: Date&time (Local) or Date&time (Zoned)), change the date in local or zoned date&time columns, or remove the date (output: Time).
Useful for normalizing date columns or extracting time components for time-based analysis.
Note: This node does not perform shifting operations. Use the Date Shifter node for that purpose.

Options

Modification

Defines the action to be performed on the selected columns. The date can be changed, appended, or removed, with different columns being eligible for each action. For example, only time columns can have date appended, while local date&time columns can only be modified or have their date component removed.

• Change: Changes the date of a date&time column, leaving the time zone unchanged.
• Append: Appends a date to a time column, resulting in a date&time column. A time zone can optionally be set.
• Remove: Removes the date and time zone information from date&time columns, leaving only the time.

Date

The date to use when changing the date of date&time columns or appending a date to time columns.

Time zone

The time zone to use when appending a date to time columns.

Date&time columns

The date&time columns whose values are modified.

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

• No workflows found

Links

• No links available

Developers