oracle里的哪个函数等于sql的year函数？

Question

oracle里的哪个函数等于sql的year函数？急

Answer 1

EXTRACT(YEAR FROM SYSDATE) 函数应该可以

下面是例子：
SQL> SELECT '年' AS "标题", EXTRACT(YEAR FROM SYSDATE) AS "数值" FROM dual UNION ALL
2 SELECT '月' AS "标题", EXTRACT(MONTH FROM SYSDATE) AS "数值" FROM dual UNION ALL
3 SELECT '日' AS "标题", EXTRACT(DAY FROM SYSDATE) AS "数值" FROM dual;
标题 数值
------ ----------
年 2013
月 3
日 6
SQL>
结果列的数据类型 没确认过。
感觉上是 数字类型的. 因为考右对齐的。