Category: Operations
Database: Sys_Calendar
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| calendar_date | DATE | YY/MM/DD | The BUSINESSCALENDAR.calendar_date returns the default date format. |
| day_of_week | INTEGER | -(10)9 | The BUSINESSCALENDAR.day_of_week returns a integer value which ranges from 1 to 7. |
| day_of_month | INTEGER | -(10)9 | The BUSINESSCALENDAR.day_of_month returns a integer value which ranges from 1 to 31. |
| day_of_year | INTEGER | -(10)9 | The BUSINESSCALENDAR.day_of_year returns a integer value which ranges from 1 to 366. |
| day_of_calendar | INTEGER | -(10)9 | The Sys_Calendar.BUSINESSCALENDAR.day_of_calendar returns the number of days since the begin of the calendar. |
| weekday_of_month | INTEGER | -(10)9 | The BUSINESSCALENDAR.weekday_of_month returns the nth occurrence of the weekday in the month(1-5). |
| week_of_month | INTEGER | -(10)9 | The BUSINESSCALENDAR.week_of_month returns 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 BUSINESSCALENDAR.week_of_year returns the week number of year which ranges from 0 to 54. |
| week_of_calendar | INTEGER | -(10)9 | The BUSINESSCALENDAR.week_of_calendar returns the relative week number associated with the calendar to which the input date belongs. |
| month_of_quarter | INTEGER | -(10)9 | The BUSINESSCALENDAR.month_of_quarter returns the relative month number associated with the quarter to which the input date belongs. |
| month_of_year | INTEGER | -(10)9 | The BUSINESSCALENDAR.month_of_year returns the relative month number associated with the year to which the input date belongs. |
| month_of_calendar | INTEGER | -(10)9 | The BUSINESSCALENDAR.month_of_calendar returns the relative month number associated with the calendar to which the input date belongs. |
| quarter_of_year | INTEGER | -(10)9 | The BUSINESSCALENDAR.quarter_of_year returns the relative quarter number associated with the year to which the input date belongs. |
| quarter_of_calendar | INTEGER | -(10)9 | The BUSINESSCALENDAR.quarter_of_calendar returns the relative quarter number associated with the calendar to which the input date belongs. |
| year_of_calendar | INTEGER | -(10)9 | The BUSINESSCALENDAR.year_of_calendar returns the relative year number associated with the business calendar to which the input date belongs. |
| WeekBegin | DATE | YY/MM/DD | The BUSINESSCALENDAR.weekbegin returns the Week Begin of the given date to which week it belongs to. |
| WeekEnd | DATE | YY/MM/DD | The BUSINESSCALENDAR.weekend returns the Week End of the given date to which week it belongs to. |
| MonthBegin | DATE | YY/MM/DD | The BUSINESSCALENDAR.monthbegin returns the Month Begin of the given date to which Month it belongs to. |
| MonthEnd | DATE | YY/MM/DD | The BUSINESSCALENDAR.monthend returns the Month End of the given date to which Month it belongs to. |
| QuarterBegin | DATE | YY/MM/DD | The BUSINESSCALENDAR.quarterbegin returns the Quarter Begin of the given date to which Quarter it belongs to. |
| QuarterEnd | DATE | YY/MM/DD | The BUSINESSCALENDAR.quarterend returns the Quarter End of the given date to which Quarter it belongs to. |
| YearBegin | DATE | YY/MM/DD | The BUSINESSCALENDAR.yearbegin returns the year Begin of the given date to which Year it belongs to. |
| YearEnd | DATE | YY/MM/DD | The BUSINESSCALENDAR.yearend returns the year end of the given date to which Year it belongs to. |
| IsBusinessDay | BYTEINT | -(3)9 | The BUSINESSCALENDAR.isbusinessday returns whether the given date is a Business Day or not. |
| BusinessWeekBegin | DATE | YY/MM/DD | The BUSINESSCALENDAR.businessweekbegin returns the Business Week Begin of the given date to which week it belongs to. |
| BusinessWeekEnd | DATE | YY/MM/DD | The BUSINESSCALENDAR.businessweekend returns the Business Week End of the given date to which week it belongs to. |
| BusinessMonthBegin | DATE | YY/MM/DD | The BUSINESSCALENDAR.businessmonthbegin returns the Business Month Begin of the given date to which Month it belongs to. |
| BusinessMonthEnd | DATE | YY/MM/DD | The BUSINESSCALENDAR.businessmonthend returns the Business Month End of the given date to which Month it belongs to. |
| BusinessQuarterBegin | DATE | YY/MM/DD | The BUSINESSCALENDAR.businessquarterbegin returns the Business Quarter Begin of the given date to which Quarter it belongs to. |
| BusinessQuarterEnd | DATE | YY/MM/DD | The BUSINESSCALENDAR.businessquarterend returns the Business Quarter End of the given date to which Quarter it belongs to. |
| BusinessYearBegin | DATE | YY/MM/DD | The BUSINESSCALENDAR.businessyearbegin returns the Business year Begin of the given date to which Year it belongs to. |
| BusinessYearEnd | DATE | YY/MM/DD | The BUSINESSCALENDAR.businessyearend returns the Business year end of the given date to which Year it belongs to. |