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






  1. MySQL Tutorial
  2. Math Numeric Functions
  3. CONV
mysql>
mysql> select CONV(256,10,8);
+----------------+
| CONV(256,10,8) |
+----------------+
| 400            |
+----------------+
1 row in set (0.00 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)