Action | Result |
Source column | Name of the source column whose values are rounded. Source: Source table Data type: Date Specification: Mandatory |
Accuracy | 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, e.g., 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, e.g., 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. |