shiftright
This function is used to perform a signed bitwise right shift. It takes the binary number a and shifts it b positions to the right.
Syntax
shiftright(BIGINT a, BIGINT b)
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. |
Return Values
The return value is of the INT type.
If the value of a or b is NULL, NULL is returned.
Example Code
The value 2 is returned.
select shiftright(16,3);
The value 4 is returned.
select shiftright(36,3);
The value 4 is returned.
select shiftright(36.123456,3.123456);
The value NULL is returned.
select shiftright(null,3);
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot