Summary

In this chapter, you learned the fundamental facts related to standardization. It is always good to understand these to start.

ISO 8601 was approved in 1988, and due to various consecutive enhancements, it provides a relevant summary of date and time management in information technology.

First, you learned about the Date value, formed by the day, month, and year elements, followed by the Time representation. After that, you learned how these values can be grouped into one specific DateTime reference, expressing one point in time. Afterward, solutions for modeling periods of time were proposed, focusing on durations and validity intervals. Until version 2019, there was no ability to model an unlimited validity interval. This was left to the user to manage and implement.

By accepting the roots defined by ISO 8601, the user gets an overview of the definition, management, and representation complexity, and is also aware of the limitations.

Although the Oracle database...