BIT_SHIFT_RIGHT_LOGICAL (Lakehouse v2)

Shifts the bits of a numeric value to the right by a specified number of positions (logical).

Analyze Syntax

func.bit_shift_right_logical(<value>, <shift>)

Analyze Examples

func.bit_shift_right_logical(16, 2)

┌───┐
│ 4  │
└───┘

SQL Syntax

BIT_SHIFT_RIGHT_LOGICAL(<value>, <shift>)

SQL Examples

SELECT BIT_SHIFT_RIGHT_LOGICAL(16, 2);

┌───┐
│ 4  │
└───┘