0
Conv function in S.Q.L
When I entered this query in mysql select conv(150 , 3 ,10); it results 1 and when I entered select conv(9999 , 2 , 10); and it results 0 Why it happen Both are invalid
1 Answer
+ 1
You should learn below about that paragraph đđ
The CONV() function converts a number from one numeric base system to another, and returns the result as a string value.
Syntax
CONV(number, from_base, to_base)
Parameter Values
ParameterDescriptionnumberRequired. A numberfrom_baseThe numeric base system of number (a number between 2 and 36)to_baseThe numeric base system to convert to (a number between 2 and 36 or -2 and -36)
Your number( 9999) will be in 2nd numeric system.It should be in 2 nd numeric system like as 1111.