Convert Hex to Decimal

Tyson
Tyson Member
in Magic ETL

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-_ Coach

    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