conv mysql function is to convert numbers from one base to other

WE can convert any number from one mathematical base number system to another base number system by using conv() function in MySQL. Here is the syntax

conv(n,base_from, base_to);

Here n is any number and base_from is base of n ( the number ) at present. base_to is the base of the number we want to covert. Minimum base value is 2 and maximum base value is 36. Let us try one example

Select conv('b',16,2);

Here number is b of base 16 , after conversion it will have base of 2 . The output is here

Now let us try one octal number

Octal number to decimal ( base 10 )

conv(11,8,10)

In above code number 11 is of base 8 and after conversion it became decimal number of base 10. Here is our output

In conventional way it is 11=1x8¹ + 1x8⁰ , so 11 in octal is equal to 9 in decimal. You can also use MySQL oct function to covert decimal number to Octal system

Hex to binary

Hex numbers have base of 16 and binary is of base 2

select  conv('D',16,2)

Output is

Decimal to Hex

Decimal is of base 10 and Hex is of base 16

select conv(10,10,16);

The output is here

Convert numbers from decimal to Octal base system

We can convert decimal number to octal number by using oct function. Here are examples

select oct(7); // output 7
select oct(8); // out put 10
select oct(9); // out put 11
select oct(10); // out put 12

SQL Math References LOG10() LOG() ABS() to get Absolute value

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

conv():

Octal number to decimal ( base 10 )

Hex to binary

Decimal to Hex

Convert numbers from decimal to Octal base system

Subhendu Mohapatra