Examples | Business Calendars | Teradata Vantage - Example: Querying for Day of the Week Using the ISO Calendar - Analytics Database - Teradata Vantage

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

Set session calendar = iso;
Sel day_of_week from Sys_Calendar.Calendar where calendar_date = date '2011-01-01';

Result:

day_of_week
-----------
6