The result data type is a BYTE value (a fixed byte data type). The size of the byte string returned varies according to the data type of the target_arg input argument 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 | BYTE(1) | BYTE(1) |
| SMALLINT | BYTE(2) | BYTE(2) |
| INTEGER | BYTE(4) | BYTE(4) |
| BIGINT | BYTE(8) | BYTE(8) |
The default title for TO_BYTE is: TO_BYTE(target_arg).