Operators Operator

~

Bitwise NOT

Reference: DuckDB 2.0.0

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 2.0.0-rc12 ยท In your browser

Engine example ยท Run to view results.

In other engines

Snowflakebitnot()

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

SQLGlot example โ†—