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

23rd Jul 2020, 2:21 PM
Varshith
Varshith - avatar
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.
23rd Jul 2020, 2:39 PM
SùñtÎsh
SùñtÎsh - avatar