EXTRACT

EXTRACT (
{ YEAR | MONTH | DAY | HOUR | MINUTE | SECOND }
| { TIMEZONE_HOUR | TIMEZONE_MINUTE }
| { TIMEZONE_REGION | TIMEZONE_ABBR }
FROM { date_value | interval_value } )

YEAR | MONTH | DAY 는 DATE 에서 추출 가능.

HOUR | MINUTE | SECOND 는 TIME에서 추출 가능.

나머지는 TIMESTAMP와 TIME ZONE datatype에서 추출가능.

- 예 -
SELECT EXTRACT(YEAR FROM TO_DATE('2010-01-18','YYYY-MM-DD')) AS YEAR
FROM DUAL;

SELECT EXTRACT(MONTH FROM TO_DATE('2010-01-18','YYYY-MM-DD')) AS MONTH
FROM DUAL;

SELECT EXTRACT(DAY FROM TO_DATE('2010-01-18','YYYY-MM-DD')) AS DAY
FROM DUAL;

SELECT EXTRACT(HOUR FROM TIME '19:03:18')
FROM DUAL;

SELECT EXTRACT(MINUTE FROM TIME '19:03:18')
FROM DUAL;

SELECT EXTRACT(SECOND FROM TIME '19:03:18')
FROM DUAL;