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

Question

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

Answer 1

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