15.10 - Decimal Literals - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1143-151K

Declares literal strings of decimal numbers in an expression.

where:

 

Syntax element …

Specifies …

+, -

an optional sign.

The default is +.

n

any valid integer.

Decimal literals consist of the following components, reading from left-to-right:

1 Optional sign

2 Sequence of digits (including none)

3 Decimal point

4 Optional sequence of digits.

Spaces and new line characters are not allowed in a literal except after the optional sign.

Decimal literals include the following types:

  • DECIMAL
  • NUMERIC
  • The total number of digits in a decimal literal determine the precision and the number of digits to the right of the decimal point determine the scale. Leading and trailing zeros are included in the counts. The precision cannot exceed 38.

    A numeric literal that is outside the range of the INTEGER type is assigned to DECIMAL(n, 0), where n is the number of digits in the literal, excluding leading zeros.

    The following numbers are examples of decimal literals.

    3.14159
    253.
    -88.234
    .29
    2147483650

    For information on DECIMAL data types, see “DECIMAL/NUMERIC Data Types” on page 108.