What is the EXTRACT function?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the EXTRACT function?
Rating:
The EXTRACT function is used to extract and return specified values from a datetime or interval value expression. It is available on 9i, 10g, and 11g platforms. The syntax of the function is as follows:
The TIMEZONE_REGION or TIMEZONE_ABBR clause returns a string value that contains the appropriate time zone name or abbreviation.
Rating:
Was this information helpful?
Other articles
- Tip on using views.
- Tip on TRUNCATE command.
- What is a base table?
- What is SQL*Plus?
- THE FLASHBACK OPERATIONS