oracle³éÈ¡º¯Êý extract()

auhtor£ºskate
time£º2010/03/03
oracle³éÈ¡º¯Êý
½ñÌìÅóÓÑÎʸöÎÊÌ⣬ÈçºÎ³éȡʱ¼äµÄ“Сʱ”
oracleµÄ³éÈ¡º¯ÊýÊÇ extrac()Óï·¨:
SELECT EXTRACT(YEAR from SYSDATE) from DUAL; return Current Year
SELECT EXTRACT(MONTH from SYSDATE) from DUAL; return Current Month
SELECT EXTRACT(DAY from SYSDATE) from DUAL; return Current Day
SELECT EXTRACT(HOUR from TIMESTAMP '2010-10-10 10:10:10') from DUAL;
SELECT EXTRACT(MINUTE  from TIMESTAMP '2010-10-10 10:10:10') from DUAL;
Àý×ÓÈçÏ£º
SQL> SELECT EXTRACT(YEAR from SYSDATE) from DUAL
  2  ;
EXTRACT(YEARfromSYSDATE)
------------------------
                    2010
SQL> SELECT EXTRACT(month from SYSDATE) from DUAL
  2  ;
EXTRACT(MONTHfromSYSDATE)
-------------------------
                        3
SQL> SELECT EXTRACT(day from SYSDATE) from DUAL;
EXTRACT(DAYfromSYSDATE)
-----------------------
                      3
SQL> SELECT EXTRACT(hour from SYSDATE) from DUAL;
SELECT EXTRACT(hour from SYSDATE) from DUAL
ORA-30076: ¶ÔÎö³öÀ´Ô´ÎÞЧµÄÎö³ö×Ö¶Î
SQL> SELECT EXTRACT(minute from SYSDATE) from DUAL;
SELECT EXTRACT(minute from SYSDATE) from DUAL
ORA-30076: ¶ÔÎö³öÀ´Ô´ÎÞЧµÄÎö³ö×Ö¶Î
SQL> SELECT EXTRACT(HOUR from TIMESTAMP '2010-10-10 10:10:10') from DUAL;
EXTRACT(HOURfromTIMESTAMP'2010
------------------------------
                            10
SQL> SELECT EXTRACT(minute from TIMESTAMP '2010-10-10 10:10:10') from DUAL;
EXTRACT(MINUTEfromTIMESTAMP'20
------------------------------