~ (tilde sign) operator

Applies to: Databricks SQL Databricks Runtime

Returns the bitwise NOT of expr.

Syntax

~ expr

Arguments

• expr: An integral numeric type expression.

Returns

The result type matches the type of expr.

Examples

> SELECT ~ 0;
 -1

Related functions

• & (ampersand sign) operator

• bit_count function

• bit_get function

• ^ (caret sign) operator

• getbit function

• | (pipe sign) operator