around() function

Learn how to use the around() function to indicate if the first argument is within a range around the center value.

Creates a bool value indicating if the first argument is within a range around the center value.

Syntax

around(value,center,delta)

Parameters

NameTypeRequiredDescription
valueint, long, real, datetime, or timespan✔️The value to compare to the center.
centerint, long, real, datetime, or timespan✔️The center of the range defined as [(center-delta) .. (center + delta)].
deltaint, long, real, datetime, or timespan✔️The delta value of the range defined as [(center-delta) .. (center + delta)].

Returns

Returns true if the value is within the range, false if the value is outside the range. Returns null if any of the arguments is null.

Examples

The following example filters rows around specific timestamp.

range dt 
    from datetime(2021-01-01 01:00) 
    to datetime(2021-01-01 02:00) 
    step 1min
| where around(dt, datetime(2021-01-01 01:30), 1min)

Output

dt
2021-01-01 01:29:00.0000000
2021-01-01 01:30:00.0000000
2021-01-01 01:31:00.0000000