You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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

memsql> select ~8, bin(8), bin(~8);
+----------------------+--------+------------------------------------------------------------------+
| ~8                   | bin(8) | bin(~8)                                                          |
+----------------------+--------+------------------------------------------------------------------+
| 18446744073709551607 | 1000   | 1111111111111111111111111111111111111111111111111111111111110111 |
+----------------------+--------+------------------------------------------------------------------+