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、