Having som trouble with some SQL in oracle.
Is it possible to retreive the date range of a specified week? So if I input week 10 I would get the dates within that week. Or just the start date.
It's easy to do the other way around (getting the week from a date).
select to_char('10-AUG-2004', 'iw') from dual;
But this is more complicated.
Any idea guys?
Any help would be appriciated.