CAST function

CAST is a complex function that transforms values from one data type to another.

Syntax

CAST transforms the value of one data type into another data type. precision and scale can be integer literals only. Expressions are not supported.

See CAST specification for more information about using CAST. For a description of precision, scale, and interval_qualifier, see ESQL data types.

Related concepts
ESQL

Related tasks
Developing ESQL
Casting data from message fields

Related reference
Syntax preference
Complex ESQL functions
CAST specification
Supported casts
Implicit casts
Data types of values from external sources