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!

populate week number: week starts from saturday

967121Dec 21 2012 — edited Dec 21 2012

Hi All,

We populated the calendar table where we have populated the week number (1-53) by taking sunday as the week start date.

But we need to populate the weeknumber(1-53), with week start day as saturday.Please

Here is the alredy populated data.
Day WeekNumber Mon date
Sunday 1 January 1/1/2012
Monday 1 January 1/2/2012
.
.
saturday 1 January 1/7/2012
Sunday 2 January 1/8/2012

we have to populate the weeknumber with saturay as the weekstart date

Thanks All.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 18 2013

Added on Dec 21 2012

5 comments

604 views