to_char

来源:互联网 发布:硬盘划伤 数据恢复 编辑:程序博客网 时间:2024/04/29 18:26

1.SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS AM') FROM DUAL

TO_CHAR(SYSDATE,'YYYY-MM-DDHH2
2013-09-23 16:37:45 午後

2.SELECT TO_CHAR(SYSDATE,'ddspth') FROM DUAL

 TO_CHAR(SYSDATE,'DDSPTH')
 twenty-third

3.select to_char(SYSDATE,'A.D.YYYY') FROM DUAL  

公元

4.select to_char(SYSDATE,'W') FROM DUAL

第4周

5.select to_char(123.45678,'$99999.999') FROM DUAL
$123.457

6.select to_char(123456789,'L999G999G999D99','NLS_CURRENCY=%') FROM DUAL

%123,456,789.00、



原创粉丝点击