The result data type is the same type as that of the numeric_value argument. For example, if the data type of numeric_value is DECIMAL/NUMERIC, the return type is DECIMAL/NUMERIC with the same precision and scale as the numeric_value argument.
For information on the default data type formats, see Teradata Vantage™ - Data Types and Literals, B035-1143.