你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。
toint()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Converts the input to an integer value (signed 32-bit) number representation.
Note
When possible, use int literals instead.
Syntax
toint(value)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| value | scalar | ✔️ | The value to convert to an integer. |
Returns
If the conversion is successful, the result is an integer. Otherwise, the result is null. If the input includes a decimal value, the result truncate to only the integer portion.
Example
Convert string to integer
The following example converts a string to an integer and checks if the converted value is equal to a specific integer.
print toint("123") == 123
|project Integer = print_0
Output
| Integer |
|---|
| true |
Truncated integer
The following example inputs a decimal value and returns a truncated integer.
print toint(2.3)
|project Integer = print_0
Output
| Integer |
|---|
| 2 |