16.20 - Result Type - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

The result data type is the same type as that of the numeric_value argument.

If the data type of numeric_value is DECIMAL/NUMERIC with a precision less than 38, the return DECIMAL/NUMERIC value will have its precision increased by 1. For example, a DECIMAL(6,4) argument is returned as a DECIMAL(7,4). If the precision is 38, the scale will be reduced by 1 unless the scale is 0. For example, a DECIMAL(38,38) argument is returned as DECIMAL(38,37).

For information on the default data type formats, see Teradata Vantageā„¢ Data Types and Literals, B035-1143.