BIGINT Data Type | Data Types and Literals | Teradata Vantage - 17.10 - BIGINT Data Type - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

Represents a signed, binary integer value from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.

Syntax

BIGINT [ attributes [...] ]

Syntax Elements

attributes
Appropriate data type attributes, column storage attributes, or column constraint attributes.
See Core Data Type Attributes and Storage and Constraint Attributes for specific information.

Usage Notes

  • Storage

    BIGINT values are stored as eight bytes with the least significant byte first.

  • External Representation of BIGINT

    The following table lists the client representations for the Teradata BIGINT data type.

    Determining the application definitions and client data types is the responsibility of the application programmer.

    Client CPU Architecture Client Representation
    IBM mainframe Eight byte 64-bit signed 2’s complement binary number, most significant byte first.
    • UTS
    • RISC
    • Motorola 68000
    • WE 32000
    Eight byte 64-bit signed 2’s complement binary number, most significant byte first.
    Intel Eight byte 64-bit signed 2’s complement binary number, least significant byte first.
  • Format

    For information on the default display format, see Data Type Default Formats.

Example: BIGINT Data Type

In the following table definition, column Total is a BIGINT data type:

CREATE TABLE RelevantNumbers
  (Id CHAR(9)
  ,LastSummary INTEGER
  ,Total BIGINT);