The real data type
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
The real data type represents a 64-bit wide, double-precision, floating-point number.
By default, decimal numbers and numbers represented with scientific notation are of type real.
real literals
To specify a real literal, use one of the following syntax options:
| Syntax | Description | Example |
|---|---|---|
| number | A real number represented by one or more digits, followed by a decimal point, and then one or more digits. | 1.0 |
numbereexponent |
A real number represented by scientific notation. | 1e5 |
real(null) |
Represents the null value. | |
real(nan) |
Not-a-number (NaN), such as when dividing a 0.0 by another 0.0. |
|
real(+inf) |
Positive infinity, such as when dividing 1.0 by 0.0. |
|
real(-inf) |
Negative infinity, such as when dividing -1.0 by 0.0. |
Learn more about syntax conventions.