Important
The SingleStore 10 release candidate (RC) gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 10.
CONV
On this page
The CONV() function 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_tobase to_base -
Returns
NULLif any argument isNULL
Example
SELECT CONV('6E',18,8);
+-----------------+
| CONV('6E',18,8) |
+-----------------+
| 172 |
+-----------------+
1 row in set (0.06 sec)Last modified: