>>> (gt gt gt sign) operator

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 15.4 and above

Returns expr bitwise unsigned right shifted by n bits. This operator is a synonym for shiftrightunsigned function.

Syntax

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

> SELECT 4 >>> 1;
 2
> SELECT -4 >>> 1;
 2147483646
> SELECT 1 >>> -1;
 0
  • อัปเดตล่าสุดเมื่อ