Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.


Converts numbers between different number bases.


CONV(N, from_base, to_base);


  • N: interpreted as an integer, but can be specified as an integer or a string
  • Minimum base is 2
  • Maximum base is 36

Return Type

  • Returns a string representation of N, converted from from_base to to_base
  • Returns NULL if any argument is NULL


SELECT CONV('6E',18,8);
| CONV('6E',18,8) |
| 172             |
1 row in set (0.06 sec)