<<<<<<< HEAD bitand | H2 | SQLDoc
Skip to main content

bitand

1. BITAND Function

======= bitand | H2 Function | SQLDoc

bitand

1. BITAND Function

>>>>>>> 9d19b1c8cb744c8e86d5c15b74d8b5f719ad62be

The BITAND function in H2 database is used to perform a bitwise AND operation on two integers.

2. Syntax

The syntax for the BITAND function in H2 database is as follows:

BITAND(value1, value2)

Arguments

  • value1, value2: The integers on which the bitwise AND operation needs to be performed.

Return

  • The BITAND function returns the result of the bitwise AND operation as an integer.

3. Notes

  • The BITAND function in H2 database performs bitwise AND operation on the binary representation of the input integers.
  • Both value1 and value2 should be integers, and the function will return NULL if any of the arguments is NULL.
  • The BITAND function can be used to extract specific bits or flags from a binary value.

4. Examples

Here are a few examples demonstrating the usage of the BITAND function in H2 database:

Example 1 - Performing a bitwise AND operation on two integers:

SELECT BITAND(5, 3) AS result;

Output:

result
------
1

Example 2 - Using BITAND to extract specific bits:

CREATE TABLE flags (
id INT PRIMARY KEY,
value INT
);

INSERT INTO flags VALUES (1, 7), (2, 10), (3, 5);

SELECT id, value, BITAND(value, 2) AS bit_1,
BITAND(value, 4) AS bit_2
FROM flags;

Output:

id | value | bit_1 | bit_2
---+-------+-------+-------
1 | 7 | 2 | 4
2 | 10 | 2 | 0
3 | 5 | 0 | 4
  • bitor - Bitwise OR operation
  • bitxor - Bitwise XOR operation