Scalar FunctionsMath Functions

binary_and

Return the bitwise AND of two 64-bit integers.

The result is a long; a null argument gives null.

Aliases: band

Syntax

binary_and(value1, value2)

Prop

Type

Returns: long

print binary_and(12, 10), binary_and(int(255), 15), binary_and(5, long(null))

print_0 (long)	print_1 (long)	print_2 (long)
8	15	null

bin_auto

Automatically bins datetime values into human-friendly intervals based on the query time range.

binary_not

Return the bitwise negation of a 64-bit integer: every bit is flipped, so `binary_not(x)` equals `-x - 1`.