TO_INT
Applies to: CELONIS 4.7
Description
TO_INT converts STRING input to INT output. If the input does not represent an integer number (or the value of the representation is outside of the supported INT range), NULL is returned.
Supported input column type: STRING. Use of the decimal separator or scientific E notation in input strings is not supported in TO_INT, and will be mapped to NULL.
Output column type: INT.
Syntax
TO_INT ( table.column )
Null handling
If the input value is NULL, the output value is NULL as well.
Example
[1] Convert strings to integers. Note the NULL output for the following STRING input:
|