money_format

description

Syntax

VARCHAR money_format(Number)

将数字按照货币格式输出，整数部分每隔3位用逗号分隔，小数部分保留2位

example

1. mysql> select money_format(17014116);
2. +------------------------+
3. | money_format(17014116) |
4. +------------------------+
5. | 17,014,116.00          |
6. +------------------------+

8. mysql> select money_format(1123.456);
9. +------------------------+
10. | money_format(1123.456) |
11. +------------------------+
12. | 1,123.46               |
13. +------------------------+

15. mysql> select money_format(1123.4);
16. +----------------------+
17. | money_format(1123.4) |
18. +----------------------+
19. | 1,123.40             |
20. +----------------------+

keywords

1. MONEY_FORMAT,MONEY,FORMAT