Archives of the TeradataForum

Message Posted: Wed, 04 Feb 2004 @ 10:14:30 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Pratibha,

you can use the sys_calendar for this:

select calendar_date, calendar_date + (7- day_of_week)
end_of_week_date
from
 sys_calendar.calendar
where calendar_date
in
('2004-02-04', '2004-02-07') ;

Thanks,

Mirjam

	<Prev	Next>		<<First	<Prev	Next>	Last>>