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_ |
int32 |
Century Number | The number of the century. | ||
DAY_ |
date |
Day Date | The date of the day. | ||
DAY_ |
int32 |
Day in Month | The number of the day in the month. | ||
DAY_ |
int32 |
Day in Week | The number of the day in the week. | ||
DAY_ |
int32 |
Day in Year Number | The number of the day in the year. | ||
DAY_ |
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_ |
int32 |
ISO Week Number | The number of the week by ISO. | ||
ISO_ |
int32 |
ISO Year Number | The number of the year by ISO. | ||
MONTH_ |
int32 |
Month Number of First Day in Week | The number of the month on the first day in the week. | ||
MONTH_ |
int32 |
Month Number of Last Day in Week | The number of the month on the seventh day in the week. | ||
MONTH_ |
int32 |
Month Number | The number of the month. | ||
WEEK_ |
int32 |
Week Number | The number of the week. | ||
YEAR_ |
int32 |
Year Number of Day 1 in Week | The number of the year on the first day in the week. | ||
YEAR_ |
int32 |
Year Number of Day 1 in Week | The number of the year on the seventh day in the week. | ||
YEAR_ |
int32 |
Year Number | The number of the year. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: