Teradata converts numeric constants as follows.
IF a UDF is passed this numeric constant value … | THEN Teradata uses this numeric data type to determine the precedence order … |
---|---|
-128 to 127 | BYTEINT |
-32768 to 32767 | SMALLINT |
-2147483648 to 2147483647 | INTEGER |
Values outside the INTEGER range and not more than 38 digits | DECIMAL |
Values with a decimal point and not more than 38 digits | |
Values with a decimal point and an exponent | REAL |