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

下面是例子：

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ù)字類型的. 因為考右對齊的。