$1,890.55格式的显示

发布时间：2020-08-19 10:52:10 来源：ITPUB博客阅读：88 作者：jichengjie 栏目：关系型数据库

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as sh

SQL> SELECT TO_CHAR(1890.55,'$99,999.99')
2 FROM DUAL;

TO_CHAR(1890.55,'$99,999.99')
-----------------------------
$1,890.55

SQL>
SQL> SELECT TO_CHAR(1890.55,'$99G999D00')
2 FROM DUAL;

TO_CHAR(1890.55,'$99G999D00')
-----------------------------
$1,890.55

SQL>
SQL> SELECT TO_CHAR(1890.55,'$99G999D99')
2 FROM DUAL;

TO_CHAR(1890.55,'$99G999D99')
-----------------------------
$1,890.55

SQL>
SQL> SELECT TO_CHAR(1890.55,'$0,000.00')
2 FROM DUAL;

TO_CHAR(1890.55,'$0,000.00')
----------------------------
$1,890.55

SQL>

向AI问一下细节

$1,890.55格式的显示

猜你喜欢

最新资讯

相关推荐

相关标签