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 |