In the following query, the input argument 23 has a data type of BYTEINT and a binary representation of 00010111. Performing a TO_BYTE operation on this value results in the hexadecimal value of 00010111 being returned with the data type of BYTE(1).
SELECT TO_BYTE(23);