Returns the expression target_arg shifted by the specified number of bits (num_bits_arg) to the left. The bits in the most significant positions are lost, and the bits in the least significant positions are filled with zeros.
- SHIFTLEFT Function Syntax
- SHIFTLEFT Argument Types and Rules
- SHIFTLEFT Result Type and Attributes
- Example: Querying with the SHIFTLEFT Function
See also "Function Name Overloading" in Using Functions with CREATE/REPLACE FUNCTION (SQL Form).
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.