Date Extraction Function Extract

EXTRACT extracts and returns the value of a specified datetime field from a datetime or interval expression.

EXTRACT ({Year
| MONTH
| Day
| HOUR
| MINUTE
| SECOND
| Timezone_hour
| Timezone_minute
| Timezone_region
| Timezone_abbr
}
from {expr}
)

Sql> SELECT e.ename,extract (year from E.hiredate) E_year,extract (MONTH from E.hiredate) e_month from EMP E;
Ename e_year E_month
---------- ---------- ----------
SMITH 1980 12
ALLEN 1981 2
WARD 1981 2
JONES 1981 4
MARTIN 1981 9
BLAKE 1981 5
CLARK 1981 6
SCOTT 1987 4
KING 1981 11
TURNER 1981 9
ADAMS 1987 5
JAMES 1981 12
FORD 1981 12
MILLER 1982 1

Date Extraction Function Extract