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>

结果列的数据类型 没确认过。

感觉上是 数字类型的. 因为考右对齐的。