money_format
Description
Syntax:
VARCHAR money format (Number)
This function turns numbers into currency format: it separates every three bits of the integer part with a comma and only retains two bits of the decimal part.
Example
mysql> select money_format(17014116);
+------------------------+
| money_format(17014116) |
+------------------------+
| 17,014,116.00 |
+------------------------+
mysql> select money_format(1123.456);
+------------------------+
| money_format(1123.456) |
+------------------------+
| 1,123.46 |
+------------------------+
mysql> select money_format(1123.4);
+----------------------+
| money_format(1123.4) |
+----------------------+
| 1,123.40 |
+----------------------+Keywords
MONEY_FORMAT,MONEY,FORMAT