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. +----------------------+

keyword

MONEY_FORMAT,MONEY,FORMAT