Scalar. Returns the value of an expression after shifting the bits right a specific number of positions.
Syntax
BITSHIFTRIGHT(
expression, count
)
Parameters|
expression
|
The initial value.
|
|
count
|
How many positions to shift. The same number of left-most bits are set to zero.
|
Data Types|
Return
|
expression
|
count
|
|---|
|
Integer
|
Integer
|
Integer
|
|
Long
|
Long
|
Integer
|
Example
INSERT INTO OutStream
SELECT BITSHIFTLEFT(InStream.IntColumn, 5)
FROM InStream;