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 string2
36
N
, converted from from_base
to to_base
NULL
if any argument is NULL
SELECT CONV('6E',18,8);
+-----------------+
| CONV('6E',18,8) |
+-----------------+
| 172 |
+-----------------+
1 row in set (0.06 sec)