CALENDAR: Data Dictionary Calendar
read only
- Catalogus:
DataDictionary - Schema:
Invantive - Label: Calendar
Mapping from dates to date-related integers such as year and day in week.
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel CALENDAR worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CENTURY_ |
int32 |
Eeuwnummer | The number of the century. | ||
DAY_ |
date |
Dag Datum | The date of the day. | ||
DAY_ |
int32 |
Dag in Maand | The number of the day in the month. | ||
DAY_ |
int32 |
Dag in Week | The number of the day in the week. | ||
DAY_ |
int32 |
Dag in Jaar Nummer | The number of the day in the year. | ||
DAY_ |
int64 |
Dagnummer sinds 1 januari 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-weeknummer | The number of the week by ISO. | ||
ISO_ |
int32 |
ISO-jaarnummer | The number of the year by ISO. | ||
MONTH_ |
int32 |
Maandnummer van Eerste Dag in de Week | The number of the month on the first day in the week. | ||
MONTH_ |
int32 |
Maandnummer van Laatste Dag in de Week | The number of the month on the seventh day in the week. | ||
MONTH_ |
int32 |
Maandnummer | The number of the month. | ||
WEEK_ |
int32 |
Weeknummer | The number of the week. | ||
YEAR_ |
int32 |
Jaarnummer van Dag 1 in Week | The number of the year on the first day in the week. | ||
YEAR_ |
int32 |
Jaarnummer van Dag 1 in Week | The number of the year on the seventh day in the week. | ||
YEAR_ |
int32 |
Jaarnummer | The number of the year. |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: