ESQL numeric data types

ESQL supports several data types that handle numeric values, including DECIMAL, FLOAT, and INTEGER.

The following data types are collectively known as numeric data types:

Notes:
  1. INTEGER and DECIMAL types are represented exactly inside the integration node; FLOAT types are inherently subject to rounding error without warning. Do not use FLOAT if you need absolute accuracy, for example, to represent money.
  2. Various casts are possible between different numeric types. These can result in loss of precision, if exact types are cast into FLOAT.

For information about numeric functions see ESQL numeric functions.