Skip to main content
Version: current [24.3.x]

LSHIFT

Categories: Bitwise

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