Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Returns the bit at a zero-based position in an integer.
getbit
Returns NULL when an argument is NULL.
bit_get(value, position)
| Name | Type | Required | Description |
|---|---|---|---|
| value | INTEGER | Yes | The integer to inspect. |
| position | INTEGER | Yes | The bit position, counted from the least significant bit. 0 <= position < width of value (8, 16, 32 or 64). |
| Property | Value |
|---|---|
| Deterministic | Yes |
| Supports window usage | No |
| Exact result | Yes |
SELECT bit_get(5, 0) AS low_bit, bit_get(5, 1) AS next_bit, bit_get(CAST(NULL AS INT), 0) AS null_value;
| low_bit | next_bit | null_value |
|---|---|---|
| 1 | 0 | NULL |
SELECT bit_get(CAST(8 AS INT), 3) AS set_bit, bit_get(CAST(8 AS INT), 2) AS unset_bit;
| set_bit | unset_bit |
|---|---|
| 1 | 0 |