Sys_Calendar.CALENDAR_TD1310 can only be used for the system-defined calendar. If you try to use this calendar when the session calendar is ISO or COMPATIBLE, the returned values are from the system-defined calendar and are therefore invalid.
The current versions (Sys_Calendar.CALENDAR and Sys_Calendar.CALENDAR_TD_ISO_COMPATIBLE) may use embedded services system functions to compute column values. The Sys_Calendar.CALENDAR_TD1310 version computes all column values using arithmetic, which typically takes less time than computing values using UDFs.
To use the legacy TD1310 version of the view, replace the definition of Sys_Calendar.CALENDAR with the definition of Sys_Calendar.CALENDAR_TD1310. Follow these steps:
- Use this statement to view the definition of the Sys_Calendar.Calendar_TD1310 version:
SHOW VIEW Sys_Calendar.Calendar_TD1310;
- Use REPLACE to replace the definition of Sys_Calendar.CALENDAR with the definition of the Sys_Calendar.CALENDAR_TD1310 version.
The redefined current version no longer uses embedded services system functions to compute column values for the following columns:
- day_of_month
- weekday_of_month
- month_of_quarter
- month_of_year
- quarter_of_year
- year_of_calendar