LSHIFT

Shifts the bits of the numeric expression to the left.

Syntax

LSHIFT(expression1 int32, expression2 int32) → int32

  • expression1: Integer to shift.

  • expression2: The number of bits to shift by.

Examples

LSHIFT example
SELECT LSHIFT(1, 120)
-- 16777216
LSHIFT example
SELECT LSHIFT(16, 1)
-- 32

LSHIFT(expression1 int64, expression2 int64) → int64

  • expression1: Integer to shift.

  • expression2: The number of bits to shift by.

Examples

LSHIFT example
SELECT LSHIFT(1, 120)
-- 16777216
LSHIFT example
SELECT LSHIFT(16, 1)
-- 32

Last updated