Time Modifier

Modifies date&time columns by appending, changing, or removing the time component. You can append a time to date columns (output: local or zoned date&time), change the time in local or zoned date&time columns, or remove the time (output: date).
Useful for standardizing or removing time data from date&time columns for consistency in reporting.
Note: This node does not perform shifting operations. Use the Time Shifter node for that purpose.

Options

Modification

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

• Change: Changes the time of local or zoned date&time columns. The time zone will not be changed. The Modify Time Zone node can be used to change it.
• Append: Appends a time to date columns. Optionally a time zone can be appended too.
• Remove: Removes the time from local or zoned date&time columns. Time zones will be removed, too.

Time

A time value.

Time zone

If checked, the user can choose a time zone to append.

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