Definition
A numeric data type used to represent exact decimal numbers with a fixed precision and scale, where precision specifies the total number of digits and scale specifies the number of digits to the right of the decimal point.
- The Decimal data type supports exact numeric representation and does not involve rounding errors associated with floating‑point types.
- Precision defines the maximum total number of digits that can be stored, and scale defines the number of decimal places.
- In SQL implementations, Decimal is synonymous with Numeric and typically supports a maximum precision of up to 38 digits.
Related content
| Relation | Count |
|---|---|
| Value Domains implementing this Data Type | 1 |
| Distributions implementing this as Physical Data Type | 0 |