Important
Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.
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: