System Calendar View | Data Dictionary | VantageCloud Lake - System Calendar View - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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 Sys_Calendar database and the versions of the Calendar view are created when the Environment is created.

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.

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