Oracle EXTRACT Function is used to extract a value from a date or interval value. SQL Extract Function can be used with String Dates and even with SQL SYSDATE. Oracle EXTRACT Function Syntax SELECT EXTRACT( [YEAR or MONTH or DAY or HOUR or MINUTE or SECOND] [TIMEZONE_HOUR or TIMEZONE_MINUTE] [TIMEZONE_REGION or TIMEZONE_ABBR] FROM [date_value or […]