The decimal data type

Applies to: ✅ Microsoft FabricAzure Data ExplorerAzure MonitorMicrosoft 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.