Bit Functions

This section provides reference information for the bit functions in PlaidCloud Lakehouse.

BIT_SHIFT_LEFT

Learn how to use the BIT_SHIFT_LEFT bit function in PlaidCloud Lakehouse. Shifts the bits of a numeric value to the left by a specified number of positions.

BIT_SHIFT_RIGHT

Use the BIT_SHIFT_RIGHT bit function in PlaidCloud Lakehouse. Shifts the bits of a numeric value to the right by a specified number of positions (arithmetic).

BIT_SHIFT_RIGHT_LOGICAL

Use the BIT_SHIFT_RIGHT_LOGICAL bit function in PlaidCloud Lakehouse. Shifts the bits of a numeric value to the right by a specified number of positions.

BITAND

Learn how to use the BITAND bit function in PlaidCloud Lakehouse. Returns the bitwise AND of two numeric values - see syntax, examples, and output.

BITNOT

Learn how to use the BITNOT bit function in PlaidCloud Lakehouse. Returns the bitwise NOT of a numeric value - see syntax, examples, and output.

BITOR

Learn how to use the BITOR bit function in PlaidCloud Lakehouse. Returns the bitwise OR of two numeric values - see syntax, examples, and output.

BITXOR

Learn how to use the BITXOR bit function in PlaidCloud Lakehouse. Returns the bitwise XOR of two numeric values - see syntax, examples, and output.