Skip to Main Content

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!

count number of weeks in a date range

883125Apr 29 2014 — edited Apr 30 2014

Hi,

I have a date range say from april 24th to april 29th.

I need to display data for 2 weeks - april 21st(monday) to april 27th as week1 and april 28th to may 4th as week 2.

How can I do this?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2014
Added on Apr 29 2014
17 comments
10,555 views