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:
| IF the data type of target_arg is... | THEN the result type is... | AND the result format is the default format for... |
|---|---|---|
| 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 ROTATERIGHT is: ROTATERIGHT(target_arg, num_bits_arg).
For information on default data type formats, see Teradata Vantage⢠- Data Types and Literals, B035-1143.