Skip to main content

SingleStoreDB v8.1

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 from from_base to to_base

  • Returns NULL if any argument is NULL

Example

SELECT CONV('6E',18,8);
****
+-----------------+
| CONV('6E',18,8) |
+-----------------+
| 172             |
+-----------------+
1 row in set (0.06 sec)
In this section: