FORMAT(12332.1,4); : FORMAT « String Functions « MySQL Tutorial






mysql>
mysql>
mysql> SELECT FORMAT(12332.1,4);
+-------------------+
| FORMAT(12332.1,4) |
+-------------------+
| 12,332.1000       |
+-------------------+
1 row in set (0.00 sec)

mysql>








23.14.FORMAT
23.14.1.FORMAT(X,D): Formats the number X to a format like '#,###,###.##'
23.14.2.FORMAT(12332.1,4);
23.14.3.FORMAT(12332.2,0)
23.14.4.Using FORMAT with data in a table