Integer Literals - Advanced SQL Engine - Teradata Database

Declares literal strings of integer numbers in an expression.

Syntax

[ + | - ] n

+, -

An optional sign.

The default is +.

n

Any valid integer.

Components of Integer Literals

Integer literals consist of an optional sign followed by a sequence of digits. Spaces and new line characters are not allowed in a literal except after the optional sign.

Integer Literal Data Types

The data type of an integer literal is determined by the range of the literal value. The type used is the smallest that can contain the value.

A numeric literal that is outside the range of the INTEGER type is assigned to the DECIMAL type, unless it is outside the range of values that a DECIMAL type can represent. For more information, see Decimal Literals.

Numeric literals are not assigned to the BIGINT type. If you need a numeric literal that is outside the range of the INTEGER type to be of a type other than DECIMAL, you can explicitly cast the literal to the desired type. For example, you can use the CAST function to explicitly cast a numeric literal to BIGINT:

SELECT ProdID
FROM PartsTbl
WHERE CustID = CAST(9876543210 AS BIGINT);

12
0
-5

Related Topics