Skip to Main Content

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!

Need WHERE clause to filter last day in month; and second Friday in month

pstein-JavaNetAug 4 2017 — edited Aug 4 2017

Assume I have a table "mytable" with (among others) a DATE column labelled "mydate".

Now I am searching for WHERE clauses for the following filters:

1.) How do I find all rows where the date value represents the last day in month?

2.) How do I find all rows where the date value is the second friday in month?

3.) How do I find all rows where the date value is the 10th of a month?

Thank you

Peter

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2017
Added on Aug 4 2017
4 comments
831 views