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

bitnand

1. BITNAND Function

======= bitnand | H2 Function | SQLDoc

bitnand

1. BITNAND Function

>>>>>>> 9d19b1c8cb744c8e86d5c15b74d8b5f719ad62be

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