A business calendar defines business and non-business days. The significance of a day being a business day or a non-business day is user-determined. For example, a business day may be a work day, and a non-business day may be either a non-working day, a weekend day, a holiday, or a vacation day. You can define different week patterns (weekdays and weekends) and exceptions (holidays and business open and closed days) for the system-defined calendars.
- Teradata
- ISO
- COMPATIBLE
These calendars are based on the Gregorian calendar, which has 365 days in most years and 366 days in leap years. The calendars differ in their definition of weeks and whether partial weeks are allowed. You can use macros to specify weekday/weekend patterns and exceptions to the patterns.
The calendars support January 1, 1900, to December 31, 2100. The default session calendar is Teradata. Each calendar defaults to all business days. You can change that pattern using a macro. See Business Calendar Macros.
- Calendar Differences
- ISO Computation
- Business Calendar Macros
- Business Calendar Tables
- Business Calendar Views
- Business Calendar Functions
- td_week_begin
- td_week_end
- td_sunday
- td_monday
- td_tuesday
- td_wednesday
- td_thursday
- td_friday
- td_saturday
- DayNumber_Of_Week
- td_month_begin
- td_month_end
- DayNumber_Of_Month
- DayOccurrence_Of_Month
- WeekNumber_Of_Month
- td_year_begin
- td_year_end
- DayNumber_Of_Year
- WeekNumber_Of_Year
- MonthNumber_Of_Year
- td_quarter_begin
- td_quarter_end
- WeekNumber_Of_Quarter
- MonthNumber_Of_Quarter
- QuarterNumber_Of_Year
- DayNumber_Of_Calendar
- WeekNumber_Of_Calendar
- MonthNumber_Of_Calendar
- QuarterNumber_Of_Calendar
- YearNumber_Of_Calendar