Important
New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.
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: