Outdated Version
You are viewing an older version of this section. View current production version.
bitwise NOT (~)
Inverts all of the bits of a given number. This operator is unary, ie, it applies to only one argument.
Syntax
~num
Return Type
Integer
Examples
select ~8, bin(8), bin(~8);
+----------------------+--------+------------------------------------------------------------------+
| ~8 | bin(8) | bin(~8) |
+----------------------+--------+------------------------------------------------------------------+
| 18446744073709551607 | 1000 | 1111111111111111111111111111111111111111111111111111111111110111 |
+----------------------+--------+------------------------------------------------------------------+
