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.

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

828 views