I know it is a cheap hack, but I figured out how to do this fairly easily. Since I was only trying to convert 0 to 65535 dec to hex, I created an excel spreadsheet with these values in col1 and dec2hec(col1) in col2. Extended this to 65535 records and then loaded this table into Teradata...
I am trying to find a way to convert an integer value to hex in SQL. I have found the Teradata function chartohexint, but then I need to convert from int to char then from char to hex. When I do this somehow I end up with non 1 to 1 mapping between integers and the hex equivalents. Does...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.