The decimal data type
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
The decimal data type represents a 128-bit wide, decimal number.
Caution
Arithmetic operations involving decimal values are significantly slower than operations on real data type.
If your use case doesn't require very high precision, we recommend using real.
decimal literals
To specify a decimal literal, use one of the following syntax options:
| Syntax | Description | Example |
|---|---|---|
decimal(number) |
A decimal number represented by one or more digits, followed by a decimal point, and then one or more digits. | decimal(1.0) |
decimal(numbereexponent) |
A decimal number represented by scientific notation. | decimal(1e5) is equivalent to 100,000 |
decimal(null) |
Represents the null value. |
Learn more about syntax conventions.