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!

Count of number of occurences of a day between two dates

birdyFeb 6 2014 — edited Feb 7 2014

I have a requirement in my code to count the number of times a day occurs between two dates. So for eg if

start date = 01 Jan 2014

end date = 31 March 2014

The number of times day 1 occurs is thrice. Hence I want the result to be 3. My three input parameters are the day number,start and end dates. I know this can be done by parsing through the days and incrementing a counter of sorts but can it be done without any looping etc?

Just looking for options

Thanks

Birdy

This post has been answered by Partha Sarathy S on Feb 6 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 7 2014

Added on Feb 6 2014

11 comments

4,988 views