`~` (bitwise NOT)¶

The bitwise NOT operator (~) is a unary operator used to invert the bits of a binary value. It converts each 0 to a 1 and each 1 to a 0, resulting in the ones’ complement of the original value.

Syntax¶

~ expr --> integer

expr ::= integer

Arguments¶

Parameter	Description
`expr`	Integer expression

Returns¶

Returns an integer that is the bitwise NOT of the input and preserves the data type of the argument supplied.

Notes¶

If the value is NULL, the result is NULL.

Examples¶

master=> SELECT ~16, ~24;
-17,-25

master=> SELECT ~101, ~110;
-102,-111

master=> SELECT ~32, ~64;
-33,-65

master=> CREATE OR REPLACE TABLE t (xtinyInt tinyInt, xsmallInt smallInt, xint int, xbigInt bigInt);

master=> INSERT INTO t VALUES (1,1,1,1);

master=> SELECT ~xtinyInt, ~xsmallInt, ~xint, ~xbigInt from t;

?column? | ?column?0 | ?column?1 | ?column?2 |
---------+-----------+-----------+-----------+
     254 |        -2 |        -2 |        -2 |