Computing the DAY of a week in Teradata

Computing the day of the week for a given date is possible using the view sys_calendar.calendar (or join to it), thus:

select day_of_week from sys_calendar.calendar
where calendar_date = date '2003-05-01';


day_of_week
-----------
5 [i.e. Thursday]