-
Need WHERE clause to filter last day in month; and second Friday in month
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|