如何用“."格式化数字.作为千位分隔符，以及“，"作为小数点分隔符? [英] How to format number with "." as thousand separator, and "," as decimal separator?

问题描述

如何用."格式化数字.作为千位分隔符，而，"作为MySql中的小数点分隔符?

how to format number with "." as thousand separator, and "," as decimal separator in MySql?

我正在使用

SELECT Format(myNumber，2)as myNumberFormatted FROM ...

SELECT Format(myNumber,2) as myNumberFormatted FROM ...

但是返回类型是一个数字，例如:

But return type is a number like:

1,000,000.00

我要

1.000.000,00

在MySQL中怎么做?

How to do in MySQL ?

谢谢

推荐答案

MySQL> = 5.5:

MySQL>=5.5:

SELECT FORMAT(10000000.5, 2, 'de_DE') AS format

MySQL< 5.5:

MySQL<5.5:

SELECT REPLACE(REPLACE(REPLACE(FORMAT(10000000.5,2), ',', ':'), '.', ','), ':', '.') AS format

这篇关于如何用“."格式化数字.作为千位分隔符，以及“，"作为小数点分隔符?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！