I am new to the forum and topic teradata generally esou trying to do a conversion of a varchar column to hex, but I'm not getting a satisfactory result. In Oracle to convert a hex to varchar (select to_char ('141865918893551308', 'fmXXXXXXXXXXXXXXXXX')) I get the result '01F8024D35626ECC', which is correct, but in teradata to perform this conversion (SELECT CHAR2HEXINT ('141865918893551308')) the result is another '0031003400310038003600350039003100380038003900330
Your example will not work as-is in Oracle.
What is the datatype of your input, VarChar, VarByte or any INT?
And what do you want as output, VarChar or VarByte?
In TD14 you might utilize TO_BYTES/FROM_BYTES.
Hello Dieter, thanks for the feedback,
My example would be a VARCHAR2 in Oracle (select to_char ('141865918893551308', 'fmXXXXXXXXXXXXXXXXXXX') from dual), this example works perfectly on Oracle. The return would be a varchar.
Would have an equivalent example in Teradata?
I didn't know you can apply TO_CHAR to a CHAR :)
Hopefully you're on TD14, TO_BYTES returns BYTE which can be used as input to FROM_BYTES to get a VARCHAR again:
SELECT FROM_BYTES(TO_BYTES ('141865918893551308', 'base10'), 'base16')