Firebird Documentation IndexFirebird 2.1 Language Ref. UpdateInternal functions → BIN_SHR()
Firebird Home Firebird Home Prev: BIN_SHL()Firebird Documentation IndexUp: Internal functionsNext: BIN_XOR()

BIN_SHR()

Tip

Find a more recent version at Firebird 5.0 Language Reference: BIN_SHR()

Available in: DSQL, PSQL

Added in: 2.1

Description: Returns the first argument bitwise right-shifted by the second argument, i.e. a >> b or a/2^b.

Result type: BIGINT

Syntax: 

BIN_SHR (number, shift)
  • The operation performed is an arithmetic right shift (SAR), meaning that the sign of the first operand is always preserved.

Prev: BIN_SHL()Firebird Documentation IndexUp: Internal functionsNext: BIN_XOR()
Firebird Documentation IndexFirebird 2.1 Language Ref. UpdateInternal functions → BIN_SHR()