EXTRACT(YEAR FROM SYSDATE) 函數(shù)應(yīng)該可以

下面是例子：
SQL> SELECT '年' AS "標題", EXTRACT(YEAR FROM SYSDATE) AS "數(shù)值" FROM dual UNION ALL
2 SELECT '月' AS "標題", EXTRACT(MONTH FROM SYSDATE) AS "數(shù)值" FROM dual UNION ALL
3 SELECT '日' AS "標題", EXTRACT(DAY FROM SYSDATE) AS "數(shù)值" FROM dual;
標題 數(shù)值
------ ----------
年 2013
月 3
日 6
SQL>
結(jié)果列的數(shù)據(jù)類型 沒確認過。
感覺上是 數(shù)字類型的. 因為考右對齊的。