Science, asked by shuaibmirzadl3229, 1 year ago

What is the use of EXTRACT in Oracle?

Answers

Answered by misha10118
0
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.
Similar questions