EXTRACT() to extract and return a year, month, day, hour, minute, second, or time zone from the timestamp types or a DATE. : EXTRACT ?? Date Timestamp Functions ?? Oracle PL/SQL Tutorial HomeOracle PL/SQL TutorialIntroductionQuery SelectSetInsert Update DeleteSequencesTableTable JoinsViewIndexSQL Data TypesCharacter String FunctionsAggregate FunctionsDate Timestamp FunctionsNumerical Math Function