CONV(N,10,2) : CONV « Math Numeric Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Math Numeric Functions
  3. CONV
mysql> select CONV(100,10,2);
+----------------+
| CONV(100,10,2) |
+----------------+
| 1100100        |
+----------------+
1 row in set (0.01 sec)

mysql>








21.11.CONV
21.11.1.CONV(N,from_base,to_base): Converts numbers between different number bases
21.11.2.CONV(N,10,2)
21.11.3.SELECT CONV(-17,10,-18);
21.11.4.SELECT CONV(0xa,10,10);
21.11.5.SELECT CONV('10',10,10);
21.11.6.CONV(N,10,16).
21.11.7.CONV(N,10,8)