如题所述
那千分位怎么显示?有没有可以显示千分位的数据类型,还是像货币符号那样取值后添加?
SELECT to_char(QTY_1, 'FM999,999,999,999,999') AS QTY_1, to_char(QTY_2, 'FM999,999,999,999,999') AS QTY_2, to_char(QTY_3, 'FM999,999,999,999,999') AS QTY_3FROM TEST_DB