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!

How to calculate date fields while excluding saturday and sunday

Dino2dyMay 9 2011 — edited Jun 1 2011

Hi I use Jdeveloper 11.1.3.4

I have an Oracle Database and created a table called Vacations with 3 attributes:

user (VARCHAR)

start (date)

finish (date)

The idea is that you subtract the finish from start and get a number of vacation days used. The thing is the sum should exclude Saturday and Sunday.

Any way to do this?

This post has been answered by pollywog on Jun 1 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2011

Added on May 9 2011

35 comments

620 views