MySQL CONV()

The CONV() function in MySQL is used to convert a number from one base to another and returns the result as a string representing the converted value.

It allows you to perform base conversions between numeric systems like binary, octal, decimal, and hexadecimal.

Syntax

CONV(number, from_base, to_base)

• number: The number to be converted.
• from_base: The base of the number to be converted.
• to_base: The base to which the number should be converted.

Note: The from_base and to_base parameters define the numeric bases for the conversion and must be between 2 and 36. The function operates on positive integers and returns the result as a string.

Example

Assume we have a numbers table with a binary_value column containing numbers in binary format:

numbers Table

The following example demonstrates how to convert the binary values in the binary_value column to their decimal equivalents:

SELECT binary_value, CONV(binary_value, 2, 10) AS decimal_value
FROM numbers;

Copy to clipboard
Copy to clipboard

In this example, the CONV() function converts the binary_value from base 2 (binary) to base 10 (decimal). The output will be as follows:

If you want to convert a hexadecimal value to decimal, assume the hex_value column in the numbers table:

You can convert the hexadecimal values to decimal with the following query:

SELECT hex_value, CONV(hex_value, 16, 10) AS decimal_value
FROM numbers;

Copy to clipboard
Copy to clipboard

The output will be as follows: