toint, tolong

Use the toint function (or its synonym tolong) to convert various data types to an integer (signed 64-bit) value. This is helpful when you need to normalize numeric values from different sources into integer format for mathematical operations, comparisons, or when decimal precision isn’t required.

You typically use toint when working with numeric strings, floating-point numbers, or other types that need to be converted to integers for whole-number calculations or when working with integer-based identifiers.

Usage

Syntax

toint(value)

Parameters

Returns

If the conversion is successful, the result is an integer. If the conversion isn't successful, the result is null.

Conversion behavior

The toint function converts values based on their type:

• Integer: Returns the value unchanged.
• Float: Truncates to integer.
• Boolean: true becomes 1, false becomes 0.
• Datetime: Converts to nanoseconds since epoch as an integer.
• Duration: Converts to integer nanoseconds.
• String: Parses as a strict integer format ("+<integer>" or "-<integer>"). Hex values and other formats aren’t supported.

Use case example

Convert string representations of HTTP status codes to integers for numeric comparisons and filtering.

Query

['sample-http-logs']
| extend status_int = toint(status)
| extend is_error = status_int >= 400
| where is_error == true
| project _time, uri, status, status_int, is_error

Output

This example converts string status codes to integers, enabling numeric range comparisons to identify error responses.

List of related functions

• todouble: Converts input to real number. Use todouble when you need decimal precision, and toint when you need whole numbers.
• tostring: Converts input to string. Use tostring to convert integers back to strings when needed.

Other query languages