invantive documentation
Invantive Support ForumsLog In / Sign Up

CALENDAR: Data Dictionary Calendar

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Calendar

Mapping from dates to date-related integers such as year and day in week.

Can only retrieve data.

Table Columns

The columns of the table CALENDAR are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
CENTURY_NUMBER int32 Century Number The number of the century.
DAY_DATE date Day Date The date of the day.
DAY_IN_MONTH int32 Day in Month The number of the day in the month.
DAY_IN_WEEK int32 Day in Week The number of the day in the week.
DAY_IN_YEAR_NUMBER int32 Day in Year Number The number of the day in the year.
DAY_SINCE_19000101_NUMBER int64 Day Number since January 1, 1900 The number of days between 01/01/1900 and the day.
ERA int32 Era The era of the century.
ID int32 ID Unique ID of the day.
ISO_WEEK_NUMBER int32 ISO Week Number The number of the week by ISO.
ISO_YEAR_NUMBER int32 ISO Year Number The number of the year by ISO.
MONTH_NR_DAY1_IN_WEEK int32 Month Number of First Day in Week The number of the month on the first day in the week.
MONTH_NR_DAY7_IN_WEEK int32 Month Number of Last Day in Week The number of the month on the seventh day in the week.
MONTH_NUMBER int32 Month Number The number of the month.
WEEK_NUMBER int32 Week Number The number of the week.
YEAR_NR_DAY1_IN_WEEK int32 Year Number of Day 1 in Week The number of the year on the first day in the week.
YEAR_NR_DAY7_IN_WEEK int32 Year Number of Day 1 in Week The number of the year on the seventh day in the week.
YEAR_NUMBER int32 Year Number The number of the year.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: