xsd格式编号,5位小数(xsd format number , 5 decimal places)
我有xsd代码,它将LINE_AMOUNT值打印为14,952.59,现在我想将其显示为14,952.59000(5位小数)。
如何实现这一目标?
谢谢
I have xsd code which is printing LINE_AMOUNT value as 14,952.59 , now i want to display this as 14,952.59000(5 decimal places).
How to achieve this?
Thank you
最满意答案
SQL小提琴
查询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 |SQL Fiddle
Query 1 Either (if you want to use the current NLS values for decimal and thousands characters):
SELECT TO_CHAR( 14952.59, 'FM9G999G999G999G990D00000' ) FROM DUALResults:
| TO_CHAR(14952.59,'FM9G999G999G999G990D00000') | |-----------------------------------------------| | 14,952.59000 |Query 2 or:
SELECT TO_CHAR( 14952.59, 'FM9,999,999,999,990.00000' ) FROM DUALResults:
| TO_CHAR(14952.59,'FM9,999,999,999,990.00000') | |-----------------------------------------------| | 14,952.59000 |Update: SQL Fiddle
Query 3:
SELECT TO_CHAR( TO_NUMBER( '13,214,952.59', 'FM9G999G999G999G990D99999' ), 'FM9G999G999G999G990D00000' ) AS formatted_value FROM DUALResults:
| FORMATTED_VALUE | |------------------| | 13,214,952.59000 |Query 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 DUALResults:
| FORMATTED_VALUE | |------------------| | 13,214,952.59000 |更多推荐
发布评论