Important
The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.
In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.
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: