SQL & PL/SQL

Hi friends,

I have two questions.

Q#1. If I use

SELECT to_char('01-FEB-2010','WW') FROM dual;

I get '05'. Now I have '201005' as input. I need to get '01-FEB-2010' (or the starting date of the week) as output.

Q#2. If I use

SELECT to_char('10-JAN-2010','WW') ww, to_char('10-JAN-2010','IW') iw FROM dual;

I get '02' and '01'. But I need to get '03'. ie., The week number should start from Sunday, not from 1st day of the year (Oracle format) or ISO format.

Thanks in advance.

Edited by: Iniyavan on Aug 18, 2010 12:35 PM