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.