Mapping from dates to date-related integers such as year and day in week.
Catalog: DataDictionary
Schema: Invantive
Alias: clr
Label: Calendar
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
The columns of the view CALENDAR are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
CENTURY_NUMBER |
int32 |
Century Number |
☑ |
The number of the century. |
DAY_DATE |
datetime |
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. |
17-05-2021 11:57 Version 20.1.419-BETA+3191