> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference material for BIT_SHIFT_RIGHT

# BIT_SHIFT_RIGHT

Shifts the bits in the first argument to the right by `n` bits, where `n` is the second argument. Shifting right by `n` positions is equivalent to dividing the number by `2^n`.

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
BIT_SHIFT_RIGHT(<value>, <bits>)
```

## Parameters

| Parameter | Description                   | Supported input types |
| :-------- | :---------------------------- | :-------------------- |
| `<value>` | Specifies the value to shift. | `INT`, `BIGINT`       |
| `<bits>`  | The number of bits to shift.  | `INT`                 |

## Return Types

The `BIT_SHIFT_RIGHT` function returns a result of either type `INT` or `BIGINT`, depending on the type of the input `<expression>`.

## Examples

**Example**

The following code example shifts `0001`, the binary representation of `1`, to the right by two bits, which yields `0000`, the binary representation for `0`:

<div className="query-window">
  ```
  SELECT bit_shift_right(1, 2) AS res;
  ```

  | res <span>int</span> |
  | :------------------- |
  | 0                    |

  <p><span>Rows: 1</span><span>Execution time: 5.33ms</span></p>
</div>

**Example**

The following code example shifts `00101`, the binary representation of `5`, to the right by two bits, which yields `00001`, the binary representation for `1`:

<div className="query-window">
  ```
  SELECT bit_shift_right(5, 2) AS res;
  ```

  | res <span>int</span> |
  | :------------------- |
  | 1                    |

  <p><span>Rows: 1</span><span>Execution time: 5.64ms</span></p>
</div>

**Example**

The following code example shifts the binary representation of `-3`, which is `1111111111111101` in signed two's complement, one bit to the right, resulting in `1111111111111110`, the signed two's complement of `-2`:

<div className="query-window">
  ```
  SELECT bit_shift_right(-3, 1) AS res;
  ```

  | res <span>int</span> |
  | :------------------- |
  | -2                   |

  <p><span>Rows: 1</span><span>Execution time: 5.41ms</span></p>
</div>