This function calculates the value shifted left by the specified number of bits.
BITLSHIFT(value, shift_amt)
This function has the following arguments:
Argument | Description |
---|---|
value | Refers to a value that you want to shift. |
shift_amt | Refers to a number of bits to be shifted by. |
Shifting a number left is similar to adding zeros (0) at right end of the binary representation of that number. If shift_amt is a negative number, then the value will be shifted to right.
Accepts numeric data for both arguments. Returns numeric data.
BITLSHIFT(3,5) gives the result 96.
BITLSHIFT(1,4) gives the result 16.