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 [...] ]
- attributes
- Appropriate data type attributes, column storage attributes, or column constraint attributes.
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. |
|
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);