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!

List all days by Weekday

Jassim RahmaApr 12 2014 — edited Apr 12 2014

Hi,

I have given_date and max_date. I would like to list all dates between given_dates and max_dates (including given_date and max_date) where the weekday for the date is = the weekday of the given_date

so it given_date is Tuesday 15th April 2014 and max_date is 31 December 2020

then I would like to all Tuesdays between those days including 15th April.

can anyone help on how to do it using PL/SQL?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2014

Added on Apr 12 2014

1 comment

341 views