Skip to main content

bitnand

1. BITNAND Function​

The BITNAND function in H2 database is used to perform a bitwise AND operation on two integers and returns the result.

2. Syntax​

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

BITNAND(value1, value2)

Arguments​

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

Return​

  • The BITNAND function returns the result of the bitwise AND operation between value1 and value2 as an integer.

3. Notes​

  • The BITNAND function in H2 database performs a bitwise AND operation on the corresponding bits of value1 and value2.
  • Both value1 and value2 should be integers. If any of the values is not an integer, it will be implicitly casted to an integer.
  • The result of the bitwise AND operation will have a value of 1 only for the bits where both value1 and value2 have a 1. For all other bits, the result will be 0.

4. Examples​

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

Example 1 - Performing a bitwise AND operation:​

SELECT BITNAND(5, 3) AS result;

Output:

result
------
1

Example 2 - Performing a bitwise AND operation on column values:​

CREATE TABLE numbers (
  id INT PRIMARY KEY,
  value1 INT,
  value2 INT
);

INSERT INTO numbers VALUES (1, 5, 3), (2, 10, 6), (3, 7, 9);

SELECT id, value1, value2, BITNAND(value1, value2) AS result
FROM numbers;

Output:

id | value1 | value2 | result
---+--------+--------+-------
1  | 5      | 3      | 1
2  | 10     | 6      | 2
3  | 7      | 9      | 1
  • bitand - Perform bitwise AND operation
  • bitor - Perform bitwise OR operation
  • bitxor - Perform bitwise XOR operation