# 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

```sql
SELECT ~8, bin(8), bin(~8);

```

```output

+----------------------+--------+------------------------------------------------------------------+
| ~8                   | bin(8) | bin(~8)                                                          |
+----------------------+--------+------------------------------------------------------------------+
| 18446744073709551607 | 1000   | 1111111111111111111111111111111111111111111111111111111111110111 |
+----------------------+--------+------------------------------------------------------------------+

```

***

Modified at: February 24, 2023

Source: [/db/v9.1/reference/sql-reference/numeric-functions/bitwise-not/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/numeric-functions/bitwise-not/)

(An index of the documentation is available at /llms.txt)