SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Week Start Date from Week Number

385728Mar 17 2004 — edited Jan 13 2006

How would I display the Week Start Date and Week Number for a range of dates.

required output:

weekno weekstartdate qty
11 8/03/04 50
12 15/3/04 100
13 22/3/04 75 etc

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 10 2006

Added on Mar 17 2004

9 comments

843 views