PL/SQL (MOSC)

MOSC Banner

Oracle function for weekdays in calendar week count

edited Jul 13, 2010 9:59AM in PL/SQL (MOSC) 16 commentsAnswered ✓
Hi, I am looking for Oracle built-in functions or a combination that return
1. days in calendar week count: e.g. for input date 07/02/2010 it should return 3.
2. weekdays in calendar week count: e.g. for input date 07/02/2010 it should return 2.
3. weekenddays in calendar week count: e.g. for input date 07/02/2010 it should return 1.

If I use PLSQL, I may finally get it the result. Just to see if there is simpler way to do it.

Thanks,
Sha
 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center