Assuming today is Friday, 28 August 2009, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'FRIDAY'), 'DD-MON-RR') FROM dual;
21-AUG-09
28-AUG-09
04-SEP-09
29-AUG-09
27-AUG-09