The following example shows the number of weeks in each quarter for 2004.
SEL quarter_of_year, MAX(week_of_quarter) FROM Sys_Calendar.BusinessCalendar WHERE year_of_calendar=2004 GROUP BY 1 ORDER BY 1;
SET SESSION CALENDAR = Teradata;
Quarter_of_Year | Maximum(Week_of_Quarter) |
---|---|
1 | 13 |
2 | 13 |
3 | 13 |
4 | 13 |
SET SESSION CALENDAR = ISO;
Quarter_of_Year | Maximum(Week_of_Quarter) |
---|---|
1 | 13 |
2 | 13 |
3 | 13 |
4 | 14 |
SET SESSION CALENDAR = COMPATIBLE;
Quarter_of_Year | Maximum(Week_of_Quarter) |
---|---|
1 | 13 |
2 | 13 |
3 | 14 |
4 | 14 |