The result data type depends on the data type of the target_arg input argument that is passed to the function as shown in the following table:
target_arg Type | Result Type | Result Format is Default Format for This Type |
---|---|---|
BYTEINT | BYTEINT | BYTEINT |
SMALLINT | SMALLINT | SMALLINT |
INTEGER | INTEGER | INTEGER |
BIGINT | BIGINT | BIGINT |
VARBYTE(n) | VARBYTE(n) | VARBYTE(n) |
The maximum supported size (n) for VARBYTE is 8192 bytes.
The default title for SHIFTLEFT is: SHIFTLEFT(target_arg, num_bits_arg).