SELECT CONV('10',10,10); : CONV « Math Numeric Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Math Numeric Functions
  3. CONV
mysql>
mysql>
mysql>
mysql> SELECT CONV('10',10,10);
+------------------+
| CONV('10',10,10) |
+------------------+
| 10               |
+------------------+
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)