Parameter

The following parameters are available.

Action

Result

Source column

Name of the source column whose values are rounded.

Source: Source table

Data type: Date

Specification: Mandatory

Precision

Accuracy of the new date format, defined by the unit: Year, Quarter, Month, Day, Hour, Minute, or Second, and Interval: Depending on the selected unit, for example, 5 minutes or 1 year

Data types: Numeric, Text

Default values: 1, Minute

If the accuracy of the source column is less accurate or the same as the target column format, the original value is retained.

The date values are rounded according to the selected interval. Only the unit to be rounded is taken into account, for example, when rounding to minutes, the seconds are ignored.

Rounding type: Specifies how the selected time interval is to be rounded.

Round up for half an interval: Automatically rounds up above an interval value higher than or equal to half of the interval value

Round down for half an interval: Automatically rounds down below an interval value lower than or equal to half of the interval value

Always round up: Always rounds up, regardless of the interval value

Always round down: Always rounds down, regardless of the interval value

Target column

Name of the target column to which the converted date is written

Data type: Date

Default value: Result_1

Specification: Optional

The target column can be identical to the source column. The values in the target column are overwritten.

If the target column is not of the Date type, it is replaced by a new date column.