Decimal
The decimal data type (dec
) is used to represent 64-bit floating point
values.
- Sales prices (6.95)
- Unemployment rates (7.1)
- Interest rates (5.35)
Columns of type decimal are often used to represent values that contain a fractional part, e.g., 1.25, or numbers that fall outside the valid range for columns of type integer.
Use decimal data types when the values need to be represented contain a fractional part, or if they fall outside the valid range for integers, which is -2,147,483,646 to 2,147,483,646. For example, although UPC codes do not have a fractional part, they should be stored as a decimal data type instead of an integer because they are typically 12-digit numbers. Decimal values may be positive or negative.
Numbers cast to decimal data type are computed & stored as IEEE 754 double floating point values. In most cases, the system holds a minimum 15 places of decimal precision. The maximum is roughly 1.7976931348623158e308.
The decimal data type also holds the floating point value that represents the date and time together as a date+time value. For more information, see Date+Time.
In some places in the 1010data
Insights platform, the decimal data type (dec
) is also represented as
f
.