Convert an integer to a hex

:question:QUESTION
How to convert an integer to a hex

:white_check_mark:ANSWER
If you want to convert an integer to a hex you can check out the to_hex function:

So something like this will work:
SELECT TO_HEX(TRY_CAST(TRY_CAST(1 as string) as bytes)) as val_hex