big int Datatype Support

Adaptive Server version 15.0 supports the exact numeric datatype bigint.

This is the range of numbers allowed by the bigint datatype:


Range of signed datatypes


Whole numbers between -263 and 263 - 1 (from -9,223,372,036,854,775,808 to +9,223,372,036,854,775,807, inclusive.

Adaptive Server bigint support also adds the hextobigint, biginttohex, and count_big functions.

See the Reference Manual: Blocks.