Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 



BIGINT

Description

The BIGINT data type is used to represent big integers. The value range is available from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.

BIGINT

Remark
  • If a real number is entered for a BIG type, the number is rounded to zero decimal place and the integer value is stored.
  • Based on the precision and the range of representation, the following order applies.
  • SMALLINTINTEGERBIGINTNUMERIC
Example

If you specify 8934 as BIGINT, 8934 is stored.

If you specify 89.1 as BIGINT, 89 is stored.

If you specify 89.8 as BIGINT, 90 is stored (all digits after the decimal point are rounded).

If you specify 3458901122 as BIGINT, 3458901122 is stored.