Example: Cumulative Sales During First Week of All Quarters - ISO Calendar - Analytics Database - Teradata Vantage

This example shows how cumulative sales for the first week of all quarters are totaled using the ISO calendar.

SET SESSION calendar = ISO;
SEL Item_Code, SUM(Sale_Amt) FROM Sales_Tbl
WHERE WeekNumber_Of_Quarter(Sale_Date) = 1
GROUP BY Item_Code;

SET SESSION calendar = ISO;