17.10 - BusinessCalendar - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

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.