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






mysql>
mysql> SELECT CONV(0xa,10,10);
+-----------------+
| CONV(0xa,10,10) |
+-----------------+
| 0               |
+-----------------+
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)