16.20 - Numeric Constants - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

Teradata Database 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