MONEY_FORMAT
money_format
Description
Syntax
VARCHAR money format (Number)
The number is output in currency format, the integer part is separated by commas every three bits, and the decimal part is reserved for two bits.
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