BITWISE_NOT

​

Syntax

​

Scalar

bitwise_not(value)

​

Arguments

​

Returns

• Type: Same signed integer type as value
• Possible values: The bitwise complement of value in its input width.
• NULL behavior: Returns NULL when an argument is NULL.

​

Properties

​

Examples

​

Complement and NULL input

SELECT bitwise_not(0) AS complement, bitwise_not(CAST(NULL AS INT)) AS null_value;

​

Invert a zero value

SELECT bitwise_not(CAST(0 AS BIGINT)) AS inverted;