INTEGER Data Type

The INTEGER data type represents integer (whole number) numeric data.

Value range:

INTEGER values are represented as signed 64-bit (8-byte) integer numbers, with values ranging from -2^63 (-9,223,372,036,854,775,808) through 2^63-1 (9,223,372,036,854,775,807).

Conversion Functions:

Other data types to INTEGER data type:

• TO_INT

INTEGER data type to other data types:

• TO_REAL
• TO_STRING
• TO_TIMESTAMP

See also:

© 2004 Microsoft Corporation. All rights reserved.