Functions/Operators/~
Operators Operator

~

Bitwise NOT

Operands & returns

11 overloads

~input

Operator
Overload link input Returns
#01 BIGINT BIGINT
#02 BIT BIT
#03 HUGEINT HUGEINT
#04 INTEGER INTEGER
#05 SMALLINT SMALLINT
#06 TINYINT TINYINT
#07 UBIGINT UBIGINT
#08 UHUGEINT UHUGEINT
#09 UINTEGER UINTEGER
#10 USMALLINT USMALLINT
#11 UTINYINT UTINYINT

Example

~ example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

Snowflakebitnot()

SELECT BITNOT(-1)
In Haybarn
SELECT ~(-1)

SQLGlot example ↗