我有xsd代码LINE_AMOUNT打印值为14,952.59,现在我想将其显示为14,952.59000(小数点后5位(。
如何实现这一点?
谢谢
SQL Fiddle
查询 1任一(如果要对十进制字符和千个字符使用当前 NLS 值(:
SELECT TO_CHAR(
14952.59,
'FM9G999G999G999G990D00000'
)
FROM DUAL
结果:
| TO_CHAR(14952.59,'FM9G999G999G999G990D00000') |
|-----------------------------------------------|
| 14,952.59000 |
查询 2或:
SELECT TO_CHAR(
14952.59,
'FM9,999,999,999,990.00000'
)
FROM DUAL
结果:
| TO_CHAR(14952.59,'FM9,999,999,999,990.00000') |
|-----------------------------------------------|
| 14,952.59000 |
更新:SQL 小提琴
查询 3:
SELECT TO_CHAR(
TO_NUMBER(
'13,214,952.59',
'FM9G999G999G999G990D99999'
),
'FM9G999G999G999G990D00000'
) AS formatted_value
FROM DUAL
结果:
| FORMATTED_VALUE |
|------------------|
| 13,214,952.59000 |
查询 4:
SELECT TO_CHAR(
TO_NUMBER(
'13,214,952.59',
'FM9,999,999,999,990.99999'
),
'FM9,999,999,999,990.00000'
) AS formatted_value
FROM DUAL
结果:
| FORMATTED_VALUE |
|------------------|
| 13,214,952.59000 |
试试这个,我认为它会为你工作。
select trim(to_char(14952.59,9999999999.99999)) from dual
OUTPUT
14952.59000