The EXTRACT() function returns the value of a specified datetime field from a datetime or interval value expression. : EXTRACT « Date Timezone « Oracle PL / SQL Oracle PL / SQL Date Timezone EXTRACT The EXTRACT() function returns the value of a specified datetime field from a datetime or interval value expression.
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>
Related examples in the same category 1. EXTRACT(): return a year, month, day, hour, minute, second, or time zone from x 2. EXTRACT(MONTH FROM TO_DATE('01-JAN-2005 19:15:26', 'DD-MON-YYYY HH24:MI:SS')) 3. EXTRACT(DAY FROM TO_DATE('01-JAN-2005 19:15:26', 'DD-MON-YYYY HH24:MI:SS')) 4. EXTRACT(): get the hour, minute, and second from a TIMESTAMP returned by TO_TIMESTAMP() 5. EXTRACT(TIMEZONE_HOUR FROM TO_TIMESTAMP_TZ('01-JAN-2005 19:15:26 -7:15', 'DD-MON-YYYY HH24:MI:SS TZH:TZM') 6. EXTRACT(TIMEZONE_MINUTE FROM TO_TIMESTAMP_TZ('01-JAN-2005 19:15:26 -7:15', 'DD-MON-YYYY HH24:MI:SS TZH:TZM')) 7. EXTRACT(TIMEZONE_ABBR FROM TO_TIMESTAMP_TZ('01-JAN-2005 19:15:26 PST', 'DD-MON-YYYY HH24:MI:SS TZR')) 8. EXTRACT(TIMEZONE_REGION FROM TO_TIMESTAMP_TZ('01-JAN-2005 19:15:26 PST', 'DD-MON-YYYY HH24:MI:SS TZR')) 9. select extract( year from add_months(sysdate,36) ) "3 Years Out"