Hi there,
Is there any easy way to get the decimal numeric value of a to_hex() function?
I have a table:
info | a char(6) | b char(6)
---------+-----------+-----------
alpha | 000001 | FFFFFF
beta | 000002 | FFFFFE
...
and so on.
Now I really need the columns a and b in DECIMAL format instead of HEX. Where is the to_dec()
function? Do I have to create that myself?
I've been searching the archives but found no clue to this anywhere...
TIA
Allan Poulsen
SW. Development Engineer
Thrane & Thrane
Lundtoftegaardsvej 93D, DK-2800 Kgs. Lyngby, Denmark