This table contains year-level information about the gregorian calendar.
Module:
CAL_YEAR_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
CAL_YEAR_ID | NUMBER | 38 | 0 | True | Year identifier in YYYY format. For example, 1979. | ||
SOURCE_RECORD_ID | NUMBER | 38 | 0 | This column is for Oracle Internal use only. Integration identifier generated by formatting the date in YYYYMMDD format. | |||
CAL_YEAR_CODE | VARCHAR2 | 16 | Calendar year period. For example, 1979 | ||||
CAL_YEAR_START_DATE | DATE | Start date of the year. | |||||
CAL_YEAR_END_DATE | DATE | End date of the year. | |||||
CAL_YEAR_END_DATE_ID | NUMBER | 38 | 0 | Last day of year in YYYYMMDD format. | |||
CAL_YEAR_START_DATE_ID | NUMBER | 38 | 0 | First day of year in YYYYMMDD format. | |||
CURRENT_CAL_YEAR_CODE | VARCHAR2 | 16 | Indicates that this day belongs to current year. Possible value is Current. | ||||
YEAR_END_OR_PRV_CRNT_DATE | DATE | For current year, day before current date else year end date | |||||
TRAILING_YEAR_NUMBER | NUMBER | 38 | 0 | Indicate trailing year number | |||
YEAR_END_OR_PRV_CRNT_DATE_ALT | DATE | For current year,if current year start then year end date else day before current date else year end date |
Copyright © 2019, 2024, Oracle and/or its affiliates.