ORACLE 日期转换

shuijingping

　　C:\Documents and Settings\Administrator>sqlplus "/as SYSDBA"

　　SQL*Plus:>　　Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
　　Connected to:

　　Oracle9i Enterprise Edition>　　With the Partitioning, OLAP and Oracle Data Mining options

　　JServer>　　SQL> select current_date,extract(day from current_date) day,extract(year from cu
　　rrent_date) year from dual;
　　CURRENT_D        DAY       YEAR
　　--------- ---------- ----------
　　11-OCT-12         11       2012
　　SQL> select SYSDATE,extract(hour  from SYSDATE) hour from dual;
　　select SYSDATE,extract(hour  from SYSDATE) hour from dual
　　*
　　ERROR at line 1:
　　ORA-30076: invalid extract field for extract source-----date不可以EXTRACT 时分秒
　　SQL> SELECT EXTRACT(minute FROM TIMESTAMP '2010-10-10 10:10:10') FROM DUAL;
　　EXTRACT(MINUTEFROMTIMESTAMP'2010-10-1010:10:10')
　　------------------------------------------------
　　10