SHIFTRIGHT

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

Purpose

Returns the expression target_arg shifted by the specified number of bits (num_bits_arg) to the right. The bits in the least significant positions are lost, and the bits in the most significant positions are filled with zeros.

Syntax



TD_SYSFNLIB.
Name of the database where the function is located.
target_arg
A numeric or variable byte expression.
num_bits_arg
An integer expression indicating the number of bit positions to shift.