UnityJDBC - Bit-wise Functions

Bit functions operate on 32-bit integers.

Summary

Function Syntax Description
& expr1 & expr2 Bit-wise AND of expr1 and expr2.
BITAND BITAND(expr1, expr2) Bit-wise AND of expr1 and expr2.
BITOR BITOR(expr1, expr2) Bit-wise OR of expr1 and expr2.
BITXOR BITXOR(expr1, expr2) Bit-wise XOR of expr1 and expr2.
^ expr1 ^ expr2 Bit-wise XOR of expr1 and expr2.
| expr1 | expr2 Bit-wise OR of expr1 and expr2.

Detailed Function Descriptions

&

Syntax: expr1 & expr2

Bit-wise AND of expr1 and expr2. Equivalent to BITAND() function.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

BITAND

Syntax: BITAND(expr1, expr2)

Bit-wise AND of expr1 and expr2. Equivalent to & operator.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

BITOR

Syntax: BITOR(expr1, expr2)

Bit-wise OR of expr1 and expr2. Equivalent to | operator.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

BITXOR

Syntax: BITXOR(expr1, expr2)

Bit-wise XOR of expr1 and expr2. Equivalent to ^ operator.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

^

Syntax: expr1 ^ expr2

Bit-wise XOR of expr1 and expr2. Equivalent to BITXOR() function.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

|

Syntax: expr1 | expr2

Bit-wise OR of expr1 and expr2. Equivalent to BITOR() function.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB