Tags for hexadecimal
hexadecimal values and char- to and fro
Greetings Experts, Can convert char to hexadecimal using char2hexint function.  When the column used in unicode or latin it becomes as 
hexadecimal char conversion
ENCODING Error in Teradata v14
Hi, I need to convert hexadecimal value to a decimal value. FOr that purpose, I have created the following query.SELECT ZEROIFNULL(CAST(FROM_BYTES( TO_BYTES('0' || SUBSTR(col_a ,9,5),'base16'),'base10') AS INT)) AS col_A_dec FROM table_a
hexadecimal FROM_BYTES TO_BYTES teradata v14
ENCODING Error in Teradata v14
Hi, I need to convert hexadecimal value to a decimal value. FOr that purpose, I have created the following query.SELECT ZEROIFNULL(CAST(FROM_BYTES( TO_BYTES('0' || SUBSTR(col_a ,9,5),'base16'),'base10') AS INT)) AS col_A_dec FROM table_a
hexadecimal FROM_BYTES TO_BYTES teradata v14