Skip to contents

Returns the bitwise AND of all bits in a given expression.

Arguments

arg

TINYINT | SMALLINT | INTEGER | BIGINT | HUGEINT | UTINYINT | USMALLINT | UINTEGER | UBIGINT | UHUGEINT | BIT

Value

TINYINT | SMALLINT | INTEGER | BIGINT | HUGEINT | UTINYINT | USMALLINT | UINTEGER | UBIGINT | UHUGEINT | BIT

Overloads

  • bit_and(arg = TINYINT)

  • bit_and(arg = SMALLINT)

  • bit_and(arg = INTEGER)

  • bit_and(arg = BIGINT)

  • bit_and(arg = HUGEINT)

  • bit_and(arg = UTINYINT)

  • bit_and(arg = USMALLINT)

  • bit_and(arg = UINTEGER)

  • bit_and(arg = UBIGINT)

  • bit_and(arg = UHUGEINT)

  • bit_and(arg = BIT)

SQL examples

bit_and(A)