SQL PHP HTML ASP JavaScript articles and free scripts to download
SQL Math Functions

conv()

WE can convert any number from one base to another page 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

1011

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

9

In conventional way it is 11=1x81 + 1x80 , 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

1101

Decimal to Hex

Decimal is of base 10 and Hex is of base 16

select conv(10,10,16);

The output is here

A

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

Be the first to post comment on this article :


Google+

Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked




HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2015 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer