Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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>