BITSHIFTRIGHT()

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;