获得日期的各个部分
使用to_char(date,float) ,见下例
SQL> select sysdate from dual;
SYSDATE
-----------------
20080123 13:23:44
SQL> select to_char(sysdate,'yyyy') from dual;
TO_C
----
2008
SQL> select to_char(sysdate,'mm') from dual;
TO
--
01
SQL> select to_char(sysdate,'dd') from dual;
TO
--
23
SQL> select to_char(sysdate,'hh') from dual;
TO
--
01
SQL> select to_char(sysdate,'hh24') from dual;
TO
--
13
SQL> select to_char(sysdate,'mi') from dual;
TO
--
24
SQL> select to_char(sysdate,'ss') from dual;
TO
--
52
SQL> select to_char(sysdate,'day') from dual;
TO_CHAR(S
---------
星期三
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/526592/viewspace-236771/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/526592/viewspace-236771/