BITWISE_ARITHMETIC_SHIFT_RIGHT

​

Syntax

​

Scalar

bitwise_arithmetic_shift_right(value, shift)

​

Arguments

​

Returns

• Type: INT for TINYINT, SMALLINT and INT input; BIGINT for BIGINT input
• Possible values: The shifted integer, using its converted 32-bit or 64-bit type.
• NULL behavior: Returns NULL when an argument is NULL.

​

Properties

​

Usage notes

• The shift amount is normalized modulo the integer width. Negative and large amounts wrap into the range 0 through width - 1.
• TINYINT and SMALLINT inputs are promoted to INT.

​

Examples

​

Shift and NULL input

SELECT bitwise_arithmetic_shift_right(CAST(16 AS INT), 2) AS shifted, bitwise_arithmetic_shift_right(CAST(NULL AS INT), 2) AS null_value;

​

Keep the sign of a negative value

SELECT bitwise_arithmetic_shift_right(CAST(-8 AS INT), 1) AS shifted;

​

Limitations

• TINYINT and SMALLINT inputs produce INTEGER results. Query tools may still report the input type. Use INTEGER or BIGINT inputs to avoid this mismatch.