17.00 - BusinessCalendar - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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.