Esta página aún no está disponible en su idioma local. Estamos trabajando arduamente para agregar más versiones de idiomas. Gracias por tu apoyo.

shiftrightunsigned

Updated on 2023-10-25 GMT+08:00

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.

NOTE:

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);

The value 2 is returned.

select shiftrightunsigned(16.123456,3.123456);

The value NULL is returned.

select shiftrightunsigned(null,3);
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback