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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to count the occurences of a day suppose 'SUNDAY' in a given month?

484123Sep 9 2006 — edited Sep 11 2006

Hi folks,

Here is the gotcha!

What is the query to count the number of SUNDAYs in a given month?
Let us say SEPTEMBER. Well, it may have 4 or 5 because it depends on the year also. Since, by default, the current year is taken into consideration in Oracle,
so there is no problem of year, I guess.
what is the query to count the number of SUNDAYs or else any other given day in a month?

Your favour will be deeply appreciated.

Cheers, PCZ.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2006

Added on Sep 9 2006

24 comments

944 views