STR_TO_INT
Deprecated
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. A decimal point is allowed in input, but decimal places are ignored/truncated.
Supported input column types: STRING. Use of scientific E notation in input is not supported in STR_TO_INT
and will be mapped to NULL.
Output column type: INT
Syntax
STR_TO_INT ( table.column )
NULL handling
If the value is NULL, the result is NULL as well.
Example
[1] Convert strings to integers. The numbers 9223372036854775908 and -9223372036854775809 are outside of the supported range. | ||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||
|