Get Year, Month, Day, Hour, Minute, Second from Oracle Date column value.

Syntax:           

EXTRACT(key FROM Column_Name) 

Where Key are Following:-

• Year

• Month

• Day

• Hour

• Minute

• Second 

 For Example: SELECT EXTRACT(YEAR FROM SYSDATE) FROM DUAL