CONV

Syntax

CONV(N, from_base, to_base)

Purpose

CONV() converts numbers from one number base into another. The return value is a string converted from from_base to to_base.

• The parameter N can be an integer or string. The minimum base is 2and the maximum base is 36. N is considered a signed number if to_base is a negative number. Otherwise, N is considered an unsigned number.

• If from_base is a negative number, N is considered an integer, and the sign is ignored.

• The parameter N supports only the int and string types.

• The from_base and to_base parameters support only the decimal int type, and the value range is [-36,-2] U [2,36].

Invalid inputs can cause errors. The following are scenarios of invalid inputs:

• The from_base or to_base parameter is not of the valid decimal int type.

• The from_base or to_base parameter exceeds the value range of [-36,-2] U [2,36].

• N is not a valid numeric value. For example, the value is beyond the ranges of 0 to 9, a to z, and A to Z.

• N is beyond the value range of from_base. For example from_base is 2, but N is 3.

• N exceeds the maximum value range [-9223372036854775807,9223372036854775807] of the BIGINT type.

Examples

obclient> SELECT CONV(9223372036854775807,10,2);
+-----------------------------------------------------------------+
| CONV(9223372036854775807,10,2)                                  |
+-----------------------------------------------------------------+
| 111111111111111111111111111111111111111111111111111111111111111 |
+-----------------------------------------------------------------+
1 row in set

obclient> SELECT CONV('-acc',21,-7);
+--------------------+
| CONV('-acc',21,-7) |
+--------------------+
| -16425 |
+--------------------+
1 row in set