Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The INTBITAND function returns a comparison of the bits of each operand using an inclusive AND operator.
Syntax
INTBITAND(<int_expr_1>, <int_expr_2>)
Arguments
| Description | |
|---|---|
int_expr_1 |
An integer expression, which is used as the left-hand operand. |
int_expr_2 |
An integer expression, which is used as the right-hand operand. |
Return types
Returns a 64-bit integer.
Examples
This section contains examples of how to use this query language construct.
Bitwise AND operation
In this example, the INTBITAND function is used to perform a bitwise AND operation.
SELECT VALUE {
compareNumbers: INTBITAND(15, 25),
compareZero: INTBITAND(15, 0),
compareSameNumber: INTBITAND(15, 15),
compareDecimal: INTBITAND(15, 1.5)
}
[
{
"compareNumbers": 9,
"compareZero": 0,
"compareSameNumber": 15
}
]