MySQL digital conversion (use of conv)

MySQL digital conversion (use of conv)

CONV (N,from_base,to_base)
Converts a number between different numeric cardinality. Converts the number N from From_base to To_base and returns as a string. If any of the arguments are null, then the return value is also null. Parameter N is interpreted as an integer, but can also be specified as an integer or a string. The minimum base is 2 and the maximum base is 36. If To_base is a negative value, N is considered to be a signed number. Otherwise, N is considered unsigned. CONV work with 64-bit precision.

MySQL Tutorials > select conv (100,10,2);
+----------------+
| Conv (100,10,2) |
+----------------+
| 1100100 |
+----------------+
1 row in Set (0.00 sec)

Mysql> Select conv (100,10,16);
+-----------------+
| Conv (100,10,16) |
+-----------------+
| 64 |
+-----------------+
1 row in Set (0.00 sec)

Mysql>