Data types and display formats | Data types | |

The decimal data type (`dec`) is used to represent 64-bit floating point
values.

Columns of type decimal can store information such as:

- 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`.