bit_shift_left
Description
Shifts the binary representation of a numeric expression to the left by a specified number of bits.
This function performs an arithmetic left shift, during which the bit length does not change, 0 is appended to the end, and the high bit remains unchanged. For example, shifting 10101
to the left by one bit results in 11010
.
Syntax
bit_shift_left(value, shift)
Parameters
value
: the value or numeric expression to shift. Supported data types are TINYINT, SMALLINT, INT, BIGINT, and LARGEINT.
shift
: the number of bits to shift. The supported data type is BIGINT.
Return value
Returns a value of the same type as value
.