GETBIT returns the bit value of a binary value at the specified index.
Syntax
GETBIT(binary_value, index)
Arguments
- binary_value
-
A binary value of data type
VARBYTE. - index
-
An index number of the bit in the binary value that is returned. The binary value is a 0-based bit array that is indexed from the rightmost bit (least significant bit) to the leftmost bit (most significant bit).
Return type
INTEGER
Examples
To return the bit at index 2 of the binary value from_hex('4d'), use the following example.
The binary representation of '4d' is 01001101.
SELECT GETBIT(FROM_HEX('4d'), 2);
+--------+
| getbit |
+--------+
| 1 |
+--------+To return the bit at eight index locations of the binary value returned by from_hex('4d'), use the following example.
The binary representation of '4d' is 01001101.
SELECT GETBIT(FROM_HEX('4d'), 7), GETBIT(FROM_HEX('4d'), 6),
GETBIT(FROM_HEX('4d'), 5), GETBIT(FROM_HEX('4d'), 4),
GETBIT(FROM_HEX('4d'), 3), GETBIT(FROM_HEX('4d'), 2),
GETBIT(FROM_HEX('4d'), 1), GETBIT(FROM_HEX('4d'), 0);
+--------+--------+--------+--------+--------+--------+--------+--------+
| getbit | getbit | getbit | getbit | getbit | getbit | getbit | getbit |
+--------+--------+--------+--------+--------+--------+--------+--------+
| 0 | 1 | 0 | 0 | 1 | 1 | 0 | 1 |
+--------+--------+--------+--------+--------+--------+--------+--------+