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!

SQL to display dates excluding weekends

User_09WUGJun 16 2016 — edited Jun 16 2016

Hi,

I have a requirement in SQL that wanted to display dates (for 30 days from sysdate) excluding saturdays and sundays.

The result should display like below,

DAY1 DAY2 DAY3 DAY4 DAY5

----------------------------------------------------------------------------------------------------------------

01-JUN-2016 02-JUN-2016 03-JUN-2016 06-JUN-2016 07-JUN-2016

The dates 04-JUN & 05-JUN are excluded because those are Saturday and Sunday.

Please help me on this. Your help on this is very much appreciated.

Thanks in Advance.

Regards,

Karthik

This post has been answered by Vysakh Suresh - 3035408 on Jun 16 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 14 2016

Added on Jun 16 2016

4 comments

1,137 views