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 |