CONV(N,from_base,to_base): Converts numbers between different number bases : CONV « Math Numeric Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Math Numeric Functions
  3. CONV

Returns NULL if any argument is NULL.

The minimum base is 2.

The maximum base is 36.

If to_base is a negative number, N is regarded as a signed number.

Otherwise, N is treated as unsigned.

CONV() works with 64-bit precision.

mysql>
mysql> SELECT CONV('a',16,2);
+----------------+
| CONV('a',16,2) |
+----------------+
| 1010           |
+----------------+
1 row in set (0.00 sec)

mysql>
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)