Appendix : Operators : Data transformation operators : Round up/down date : Parameter
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, 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.
Copyright © 2013-2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback