Oracle中to_char的使用
to_char (for dates)看测试:SQL> SELECT TO_CHAR(SYSDATE,'yyyy-MM-dd HH24:MI:ss') FROM DUAL;2012-07-19 17:35:49SQL> SELECT TO_CHAR (SYSDATE,'D') FROM DUAL; (D一个星期的第几天) 5SQL> SELECT TO_CHAR (SYSDATE,'day') FROM DUAL; (day 一个星期的星期几)星期四SQL> SELECT TO_CHAR (SYSDATE,'yyy