Convert Hex to Decimal

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

  • 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`