shiftrightunsigned

This function is used to perform an unsigned bitwise right shift. It takes the binary number a and shifts it b positions to the right.

shiftrightunsigned(BIGINT a, BIGINT b)

**Table 1** Parameters
Parameter	Mandatory	Type	Description
a	Yes	DOUBLE, BIGINT, DECIMAL, or STRING	The value can be a float, integer, or string. If the value is not of the BIGINT type, the system will implicitly convert it to the BIGINT type for calculation.
b	Yes	DOUBLE, BIGINT, DECIMAL, or STRING	The value can be a float, integer, or string. If the value is not of the BIGINT type, the system will implicitly convert it to the BIGINT type for calculation.

The return value is of the INT type.

If the value of a or b is NULL, NULL is returned.

The value 2 is returned.

select shiftrightunsigned(16,3);

The value 536870910 is returned.

select shiftrightunsigned(-16,3);

The value 2 is returned.

select shiftrightunsigned(16.123456,3.123456);

The value NULL is returned.

select shiftrightunsigned(null,3);

Parent topic: Mathematical Functions

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.