Integer

The integer data type (int) is used to represent whole numbers that can be stored within 32-bits.

Columns of type integer can store information such as:
  • Transaction IDs (3026049)
  • Identification numbers (24)
  • Dates (20161201)
  • Time (121837)

Dates and time are represented by the integer data type. For more information, see Dates and time.

Valid integer values are -2,147,483,646 to 2,147,483,646.
Note: If the values, or the results of mathematical functions applied to these values, will be outside of this range, use the decimal data type or the big integer data type instead.

In some places in the 1010data Insights platform, the integer data type (int) is also represented as i.