Supporting Multiple Calendars

SQL-92 [Melton & Simon 1993], as well as the proposed SQL3 language specification, make the implicit assumption that only the Gregorian calendar will be needed by users for the representation and manipulation of time values. In this chapter we show how SQL-92 be augmented to support multiple calendars, which are needed to support the diverse semantics of time. This extension will impact most aspects of time support in SQL-92.