Caution with the BYYEARDAY specifier.
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.
Caution with the BYYEARDAY specifier.
Rating:
The BYYEARDAY specifier in a calendaring expression specifies the day of the year as a number. A certain amount of caution is required while using the BYYEARDAY specifier for a leap year. For example, the number -17 will evaluate to December 15 always.
Rating:
Was this information helpful?
Other articles
- What is the DBMS_REGISTRY package?
- What is a complete recovery?
- What is the CREATE_SNAPSHOT procedure?
- What is the DBA_TABLESPACE_GROUPS data dictionary view?
- What is DBCA?
