I am trying to convert hexadecimal numbers into binary. I haven’t been able to find a redshift function that would work.
I have tried:
select to_binary(‘4D’) (to_binary function doesn’t exist but to_hex does)
I have also tried finding a python UDF but have had no luck.
If I converted the hexadecimal 4D into binary I would expect 01001101