Operators Operator

&

Bitwise AND

Operands & returns

11 overloads

Operator

Overload link	`left`	`right`	Returns
#01	`BIGINT`	`BIGINT`	`BIGINT`
#02	`BIT`	`BIT`	`BIT`
#03	`HUGEINT`	`HUGEINT`	`HUGEINT`
#04	`INTEGER`	`INTEGER`	`INTEGER`
#05	`SMALLINT`	`SMALLINT`	`SMALLINT`
#06	`TINYINT`	`TINYINT`	`TINYINT`
#07	`UBIGINT`	`UBIGINT`	`UBIGINT`
#08	`UHUGEINT`	`UHUGEINT`	`UHUGEINT`
#09	`UINTEGER`	`UINTEGER`	`UINTEGER`
#10	`USMALLINT`	`USMALLINT`	`USMALLINT`
#11	`UTINYINT`	`UTINYINT`	`UTINYINT`

SELECT 91 & 15;

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT BITAND(BITSHIFTLEFT(255, 4), BITSHIFTLEFT(15, 2))

In DuckDB

SELECT (CAST(255 AS INT128) << 4) & (CAST(15 AS INT128) << 2)