Developing Robust Date and Time Oriented Applications in Oracle Cloud

12

Building Month Calendars Using SQL and PL/SQL

Each date value consists of the month and year value references. Therefore, it is often necessary to create reports referencing the defined granularity. For example, the evaluation of employee attendance, a project summary, or resource consumption is commonly associated with month precision. Moreover, individual activities can be bordered by the left and right borders of the duration frame. Thus, it can be necessary to get the visual form of the month in terms of individual day’s serial numbers, as well as weekday references. In the past, this had to be hardcoded. Nowadays, mostly pre-prepared visual components forming the calendar can be used.

Nevertheless, in our opinion, it is good to summarize ...