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!

Procedure to get the number of working days in a month when the user enters from and to days

OraPrinceNov 18 2014 — edited Nov 20 2014

Hi All,

Can you provide a solution to this - procedure to get the number of working days in a month when the user enters from and to days.

Suppose the user enters start date as 18th Nov 2014 and end date as 23rd Nov 2014.

The output should display

Count : 4

18 Nov 2014 Tue

19 Nov 2014 Wed

20 Nov 2014 Thu

21 Nov 2014 Fri

This will exclude the Saturdays and Sundays.

This post has been answered by Stako Botev on Nov 18 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2014

Added on Nov 18 2014

#date, #procedure

15 comments

3,429 views