Categories: Bitwise

BITWISE_NOT

Returns the bitwise NOT of the given operand.

Syntax

BITWISE_NOT(op1 NUMERIC) → NUMERIC

• op1: Value to invert.

Examples

BITWISE_NOT example

SELECT BITWISE_NOT(0)
-- -1

BITWISE_NOT example

SELECT BITWISE_NOT(9223372036854775807)
-- -9223372036854775808