SQL>
Syntax: EXTRACT([[YEAR]|[MONTH]|[DAY]|[HOUR]|[MINUTE]|[SECOND]]|
[[TIMEZONE_HOUR]|[TIMEZONE_MINUTE]|[TIMEZONE_REGION]|[TIMEZONE_ABBR])
SQL>
SQL>
SQL> SELECT
2 EXTRACT(YEAR FROM SYSDATE) current_year
3 FROM dual;
CURRENT_YEAR
------------
2008
SQL>
SQL>