shiftrightunsigned function

Applies to: Databricks SQL Databricks Runtime

Returns a bitwise unsigned right shifted by n bits.

Syntax

shiftrightunsigned(expr, n)

Arguments

• expr: An INTEGER or BIGINT expression.
• n: An INTEGER expression specifying the number of bits to shift.

Returns

The result type matches expr.

When n is negative the result is 0.

Examples

SQL

> SELECT shiftrightunsigned(4, 1);
 2
> SELECT shiftrightunsigned(-4, 1);
 2147483646

Related functions

• shiftleft function
• shiftright function