Re: Retrieving date given week no.

In article <1994Jun12.011817.996_at_tarik.demon.co.uk> larry_at_tarik.demon.co.uk (Larry Barea) writes:
>Does anyone know how I could retrieve the last sunday
>of a given week given the week number ?

I am not certain exactly what you want [the *last* Sunday of a given week is an illogical concept, a week only has *one* Sunday.]; however...

Try something similar to this the obtain the NNNth Sunday of the this year:

   select next_day(to_date('123193','mmddyy'),'SUN')+((NNN-1)*7)    from dual

Let me know if that helps.

-- 
============================================================================
Michael Sallwasser  | Down one path is utter dispair and hopelessness. Down 
Northrop Grumman    | the other is total destruction. Let us choose wisely.
============================================================================