You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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

memsql> SELECT CONV('6E',18,8);
+-----------------+
| CONV('6E',18,8) |
+-----------------+
| 172             |
+-----------------+
1 row in set (0.06 sec)