Skip to main content
Last updated on

shiftrightunsigned function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns expr bitwise unsigned right shifted by n bits. This function is a synonym for >>> (gt gt gt sign) operator.

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.

The effective shift distance is n modulo 32 for an INTEGER expr and modulo 64 for a BIGINT expr.

Examples​

SQL
> SELECT shiftrightunsigned(4, 1);
 2
> SELECT shiftrightunsigned(-4, 1);
 2147483646
> SELECT shiftrightunsigned(1, -1);
 0
> SELECT 4 >>> 1;
 2
> SELECT -4 >>> 1;
 2147483646
On this page