Category: Operations
Database: Sys_Calendar
| View Column | Data Type | Format | Description |
|---|---|---|---|
| calendar_date | DATE | YYYY/MM/DD | The default date format. |
| day_of_week | INTEGER | -(10)9 | An integer value which ranges from 1 to 7. |
| day_of_month | INTEGER | -(10)9 | An integer value which ranges from 1 to 31. |
| day_of_year | INTEGER | -(10)9 | An integer value which ranges from 1 to 366. |
| day_of_calendar | INTEGER | -(10)9 | Number of days since the begin of the calendar. |
| weekday_of_month | INTEGER | -(10)9 | The nth occurrence of the weekday in the month(1-5). |
| week_of_month | INTEGER | -(10)9 | The week number of month which ranges from 0 to 6. |
| week_of_quarter | INTEGER | -(10)9 | None |
| week_of_year | INTEGER | -(10)9 | The week number of year which ranges from 0 to 54. |
| week_of_calendar | INTEGER | -(10)9 | The relative week number associated with the calendar to which the input date belongs. |
| month_of_quarter | INTEGER | -(10)9 | The relative month number associated with the quarter to which the input date belongs. |
| month_of_year | INTEGER | -(10)9 | The relative month number associated with the year to which the input date belongs. |
| month_of_calendar | INTEGER | -(10)9 | The relative month number associated with the calendar to which the input date belongs. |
| quarter_of_year | INTEGER | -(10)9 | The relative quarter number associated with the year to which the input date belongs. |
| quarter_of_calendar | INTEGER | -(10)9 | The relative quarter number associated with the calendar to which the input date belongs. |
| year_of_calendar | INTEGER | -(10)9 | The relative year number associated with the business calendar to which the input date belongs. |
| WeekBegin | DATE | YYYY/MM/DD | The beginning of the week to which the given date belongs. |
| WeekEnd | DATE | YYYY/MM/DD | The end of the week to which the given date belongs. |
| MonthBegin | DATE | YYYY/MM/DD | The beginning of the month to which the given date belongs. |
| MonthEnd | DATE | YYYY/MM/DD | The end of the month to which the given date belongs. |
| QuarterBegin | DATE | YYYY/MM/DD | The beginning of the quarter to which the given date belongs. |
| QuarterEnd | DATE | YYYY/MM/DD | The end of the quarter to which the given date belongs. |
| YearBegin | DATE | YYYY/MM/DD | The beginning of the year to which the given date belongs. |
| YearEnd | DATE | YYYY/MM/DD | The end of the year to which the given date belongs. |
| IsBusinessDay | BYTEINT | -(3)9 | Indicates whether the given date is a Business Day. |
| BusinessWeekBegin | DATE | YYYY/MM/DD | The beginning of the business week to which the given date belongs. |
| BusinessWeekEnd | DATE | YYYY/MM/DD | The end of the business week to which the given date belongs. |
| BusinessMonthBegin | DATE | YYYY/MM/DD | The beginning of the business month to which the given date belongs. |
| BusinessMonthEnd | DATE | YYYY/MM/DD | The end of the business month to which the given date belongs. |
| BusinessQuarterBegin | DATE | YYYY/MM/DD | The beginning of the business quarter to which the given date belongs. |
| BusinessQuarterEnd | DATE | YYYY/MM/DD | The end of the business quarter to which the given date belongs. |
| BusinessYearBegin | DATE | YYYY/MM/DD | The beginning of the business year to which the given date belongs. |
| BusinessYearEnd | DATE | YYYY/MM/DD | The end of the business year to which the given date belongs. |