Su, Xiaomeng 76a5b1ee83 dli_sqlreference_20240227

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>

2024-03-27 22:02:33 +00:00

7.0 KiB

Raw Permalink Blame History

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.

Syntax

shiftrightunsigned(BIGINT a, BIGINT b)

Parameters

**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.

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 shiftrightunsigned(16,3);

The value 536870910 is returned.

select shiftrightunsigned(-16,3);