CONV
Converts numbers between different number bases.
Syntax
CONV(N, from_base, to_base);
Arguments
N
: interpreted as an integer, but can be specified as an integer or a stringMinimum base is
2
Maximum base is
36
Return Type
Returns a string representation of
N
, converted fromfrom_base
toto_base
Returns
NULL
if any argument isNULL
Example
SELECT CONV('6E',18,8); **** +-----------------+ | CONV('6E',18,8) | +-----------------+ | 172 | +-----------------+ 1 row in set (0.06 sec)