select to_char(sysdate,'YYYY') year from dual;--得到的是当前的年份
select EXTRACT(year FROM to_date('2009-11-10','yyyy-mm-dd')) year from dual;
4位year: SQL> select to_char(sysdate,'yyyy') from dual;TO_CHAR(SYSDATE,'YYYY') ----------------------- 20092位year: SQL> select to_char(sysdate,'yy') from dual;TO_CHAR(SYSDATE,'YY') --------------------- 09
select to_char(sysdate,'yyyy') from dual;
SELECT EXTRACT(YEAR FROM TO_DATE('2009-11-10', 'yyyy-mm-dd')) YEAR FROM DUAL;这个挺好。
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(year FROM to_date('2009-11-10','yyyy-mm-dd')) year from dual;
SQL> select to_char(sysdate,'yyyy') from dual;TO_CHAR(SYSDATE,'YYYY')
-----------------------
20092位year:
SQL> select to_char(sysdate,'yy') from dual;TO_CHAR(SYSDATE,'YY')
---------------------
09
FROM DUAL;这个挺好。
SELECT EXTRACT(MONTH FROM SYSDATE) FROM DUAL; --return Current Month
SELECT EXTRACT(DAY FROM SYSDATE) FROM DUAL; --return Current Day