TOINTEGER
Syntax
TOINTEGER (expression)
Description
Converts numeric or string data to an Integer32 value.
Arguments
| expression | The number or string value to convert. expression can be: — Boolean — Byte — Decimal — Double (any) — String — Unsigned Integer (any) |
Returns
An Integer32 value.
Remarks
Trying to convert DateTime data to Integer results in an error.
Example
If EmployeeNum contains the value 4753:
TOINTEGER(MyEntity.EmployeeNum)
Returns: 4753 as an Integer32
The same value as an Integer32 data type, which allows it to meet target schema definition as well as be used in other functions.