Search found 1 match
- Wed Jul 22, 2015 5:37 pm
- Forum: Vertica SQL Functions
- Topic: Convert Hex to decimal on table column in vertica
- Replies: 1
- Views: 15458
Convert Hex to decimal on table column in vertica
Hi Experts, I need to convert a string field from HEX to Decimal value in vertica DB. The length of the number is about '03EA053BAF20' which needs to be converted to '1050694586' and updated in the same column in the table. I need to do this for a table with data about 100M. Can you suggest the best...