15.10 - BIGINT Data Type - Teradata Database

Teradata Database SQL Data Types and Literals

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

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

where:

 

Syntax element …

Specifies …

attributes

appropriate data type attributes, column storage attributes, or column constraint attributes.

See “Core Data Type Attributes” on page 17 and “Storage and Constraint Attributes” on page 18 for specific information.

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

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.

    For information on the default display format, see “Data Type Default Formats” on page 281.

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

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