Convert Hex to Decimal

Tyson
Tyson ⚪️
in Data Platform & Data Science

I have a hex data point that I need to parse and convert to numeric values.  Has anyone done this and what would someone recommend?  SQL?

Comments

  • ST_-Superman-_
    ST_-Superman-_ 🟤

    You would need to do this in a MySQL dataflow, but I believe you can use the CONV() function there

     

    SELECT
    CONV(`hex field`,16,10) as `decimal field`

    ______________________________________________________________________________________________
    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
    ______________________________________________________________________________________________

Categories