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!

Finding Dates of a particular week day using sql

3303426Mar 2 2017 — edited Mar 2 2017

My oracle db version is - 11.2.0.4.0

Can I find the date of a day, that is on which dates the saturdays and sundays of a specific month fall.

For e.g Consider the month of JANUARY-2017. The following dates are weekends

7/1/2017 - Saturday

14/1/2017 - Saturday

21/1/2017 - Saturday

28/1/2017 - Saturday

1/1/2017 - Sunday

8/1/2017 - Sunday

15/1/2017 - Sunday

22/1/2017 - Sunday

29/1/2017 - Sunday

I want a SQL query for this such that when I give Month and Year as input it should give me all the above dates (only dates of saturday and sunday) of that month-year as output

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 30 2017

Added on Mar 2 2017

#sql-pl-sql

7 comments

846 views