STR_TO_INT
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6
Description
STR_TO_INT converts the input strings to integers. If the input is not a number (or outside of the supported range), null is returned. If the input is a float, the decimal places are ignored.
Supported input column types: STRING
Output column type: INT
NULL values: If the value is NULL, the result is NULL.
Syntax
STR_TO_INT ( table.column )
Example
[1] Convert strings to integers. The numbers 9223372036854775908 and -9223372036854775809 are outside of the supported range.
|