Skip to main content

FLOAT

Description

The Celonis implementation of floating point numbers follows the IEEE Standard for Floating-Point Arithmetic (IEEE 754) with 64-bit precision. Floating point numbers that hold not-a-number (NaN) values are mapped to NULL.

Floating point constants use a period as the decimal separator.

Example

[1]

Create three float values:

Query

Column1

- 0.5

Column2

0.0

Column3

0.5

Input

Output

Result

Column1 : float

Column2 : float

Column3 : float

-0.5

0.0

0.5

See also: