Example: Querying for Beginning of the Week Using the COMPATIBLE calendar - Analytics Database - Teradata Vantage

This query returns the beginning of the week using the COMPATIBLE calendar:

Set session calendar = compatible;
Sel weekBegin from Sys_Calendar.BusinessCalendar where calendar_date = date '2011-01-01';

Result:

WeekBegin
-----------
11/01/01