Optional Syntax Elements for TD_RoundColumns - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢
PrecisionDigit
Specify the number of decimal places to which to round values.
If precision is positive, the function rounds values to the right of the decimal point.
If precision is negative, the function rounds values to the left of the decimal point.
Default: If the PrecisionDigit value is not provided, the function rounds the column values to 0 places.
If the column values have the DECIMAL/NUMERIC data type with a precision less than 38, then the function increases the precision by 1. For example, when a DECIMAL (4,2) value of 99.99 is rounded to 0 places, the function returns a DECIMAL (5,2) value, 100.00. However, if the precision is 38, then the function only reduces the scale value by 1 unless the scale is 0. For example, the function returns a DECIMAL (38, 36) value of 99.999999999 as a DECIMAL (38, 35) value, 100.00.
Accumulate
Specify the names of the InputTable columns to copy to the output table.