Oracle function for weekdays in calendar week count
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
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
0