~ (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

SQL

> SELECT ~ 0;
 -1

Related functions

• & (ampersand sign) operator
• bit_count function
• bit_get function
• ^ (caret sign) operator
• getbit function
• | (pipe sign) operator