Example: Querying for Beginning of the Week Using the ISO Calendar - Advanced SQL Engine - Teradata Database

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

Set session calendar = iso;
Sel weekBegin from Sys_Calendar.BusinessCalendar where calendar_date = date '2011-01-01';
WeekBegin
-----------
10/12/27