Question

What is the use of EXTRACT in Oracle?

Answer 1

To extract values of HOUR, MINUTE, and SECOND fields, you use TO_CHAR() function. For the INTERVAL YEAR TO MONTH, you can extract only YEAR and MONTH fields. In this tutorial, you have learned how to use the Oracle EXTRACT() function to extract a value of a specified field of a date time value.