Outdated Version
You are viewing an older version of this section. View current production version.
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 string- Minimum 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
memsql> SELECT CONV('6E',18,8);
+-----------------+
| CONV('6E',18,8) |
+-----------------+
| 172 |
+-----------------+
1 row in set (0.06 sec)