BITNOT Function | VantageCloud Lake - BITNOT - Teradata Vantage

Performs a bitwise complement on the binary representation of the input argument.

The bitwise NOT, or complement, is a unary operation which performs logical negation on each bit, forming the ones complement of the specified binary value. The digits in the argument which were 0 become 1, and the reverse.

• BITNOT Function Syntax
• BITNOT Argument Types and Rules
• BITNOT Result Type and Attributes
• Example: Querying with the BITNOT Function

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.