Skip to main content
Version: Latest-3.3

conv

Description

Converts the number x from one numeric base system to another, and returns the result as a string value.

Syntax

CONV(x,y,z);

Parameters

  • x: the number to be converted. VARCHAR or BIGINT is supported.
  • y: the source base. TINYINT is supported.
  • z: the target base. TINYINT is supported.

Return value

Returns a value of the VARCHAR data type.

Examples

Convert the number 8 from numeric base system 2 to numeric base system 10:

mysql> select conv(8,10,2);
+----------------+
| conv(8, 10, 2) |
+----------------+
| 1000 |
+----------------+
1 row in set (0.00 sec)