Developing Robust Date and Time Oriented Applications in Oracle Cloud by Michal Kvet

Author:Michal Kvet
Language: eng
Format: epub
Publisher: Packt Publishing Ltd.
Published: 2023-04-19T00:00:00+00:00

Summary

In this chapter, you got familiar with the existing functionalities in DBS Oracle, mostly related to day and month granularity. We emphasized the ADD_MONTHS and MONTH_BETWEEN functions for dealing with month precision.

Mathematical arithmetic applies a day precision shift. Therefore, this chapter referenced the LAST_DAY function for providing the last day of the month and the NEXT_DAY function, which provides the closest larger DATE value according to the specified weekday. The weekday value is set by the string abbreviation; alternatively, the serial number of the day within the week is used. However, as we have shown, these values depend on the region, language, or territory. Therefore, our own implementation for getting the next day was proposed and discussed.

In addition, we learned the principles of DATE value rounding and truncating. Then, the PERSONAL_ID value was introduced, which can be used as the primary key for a person table, providing composite information about the gender and date of birth of a person. The PERSONAL_ID value itself is divisible by 11, making the solution resistant to errors and typos. Finally, we summarized the possibilities of generating a random date, both by explicitly managing individual elements and by applying a numerical shift.

While describing the various methods and parameters, we pointed out the meaning of the parameter value, which can be influenced by the parameters of the session or server. In the next chapter, we will guide you through the complexity of the NLS parameters while pointing to the individual values, impacts, and data dictionary to get the current set (or inherited) value.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.