15.00 - Exact Numeric Data Types - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Exact Numeric Data Types

The definition of an exact numeric data type used by the ANSI/ISO SQL:2011 standard states that to be an exact numeric, the type must have a precision and a scale expressed either in base 2 or base 10.

According to the ANSI/ISO SQL:2011 standard, the following types are members of the exact predefined numeric set.

The following types are members of the set of true integers.

  • BIGINT
  • INTEGER
  • SMALLINT
  • The following types are members of the set of fractional exact numeric types.

  • DECIMAL
  • NUMERIC
  • Teradata also supports the following exact predefined numeric data type extensions to the ANSI/ISO SQL:2011 standard.

     

                                    Data Type

                                    Type Family

    BYTEINT

    true integer

    NUMBER(p)

    fractional exact numeric

    Note: You can use the NUMBER type to represent both fixed point and floating point values, depending on the syntax you use to specify the value.

    See SQL Data Types and Literals for more detailed information about the various exact numeric data types supported by Teradata Database.