Purpose
This function rotates the bits of a number by the specified number to the left.
Syntax
bit_lrotate::=
Usage Notes
- Bit functions are limited to 64 bits, which is positive numbers between 0 and 18446744073709551615.
- The second parameter can be between 0 and 63.
- The result data type is
DECIMAL(20,0).
Example
Copy
SELECT BIT_LROTATE(1024,63);