System Calendar View | Data Dictionary | Teradata Vantage - 17.00 - System Calendar View - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

The Sys_Calendar.CALENDAR system view helps to extend the properties of a DATE data type column by means of a join. The columns of the view contain data only for the active calendar for the session.

The calendar dates range from 1900 to 2100 and are stored in a table in the Sys_Calendar database.

The administrator must run DIPCAL SQL and DIPSYSFNC scripts from the DIP utility to create the Sys_Calendar database and the versions of the Calendar view.

There are three versions of the Sys_Calendar.Calendar view:
  • Sys_Calendar.CALENDAR
  • Sys_Calendar.CALENDAR_TD_ISO_COMPATIBLE (view used for the current release)
  • Sys_Calendar.CALENDAR_TD1310 (legacy view that uses arithmetic to compute column values)

Sys_Calendar.CALENDAR and Sys_Calendar.CALENDAR_TD_ISO_COMPATIBLE have the same definition after running the DIP utility.

The current version (Sys_Calendar.CALENDAR_TD_ISO_COMPATIBLE) is an internal view and can only be accessed by user DBC.