shiftright function

Applies to: Databricks SQL Databricks Runtime

Returns a bitwise signed right shifted by n bits.

Syntax

shiftright(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 expr is negative (that is, the highest order bit is set) the result remains negative because the highest order bit is sticky. When n is negative the result is 0.

Examples

SQL

> SELECT shiftright(4, 1);
 2
> SELECT shiftright(-4, 1);
 -2

Related functions

• shiftleft function
• shiftrightunsigned function