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...
