Try to search your question here, if you can't find : Ask Any Question Now ?

How do I convert a hexadecimal number into binary in Redshift?

HomeCategory: stackoverflowHow do I convert a hexadecimal number into binary in Redshift?
Avatarpragati asked 1 month ago

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 strtol(‘4D’,2)
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.

Example:
If I converted the hexadecimal 4D into binary I would expect 01001101

1 Answers
Best Answer
AvatarMikhail answered 1 month ago
Your Answer

0 + 16 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com