Please enable JavaScript to view this site.

Data Dictionary Data Model

Navigation: » No topics above this level «

CALENDAR: Data Dictionary Calendar

Contents Previous Home Next More

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.

View Columns

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