fairyhood

导航

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

posted on 2012-07-20 09:13  fairyhood  阅读(202)  评论(0编辑  收藏  举报