select dates in a month that fall on a given day of the week
Hi
Could anyone offer some help in providing me a sql statement that will return the dates for a given day in any month.
User will provide Year and Month, I want to retreive the dates for that month that fall on a Friday for example
For example May 2009 would produce
2009-05-01
2009-05-08
2009-05-15
2009-05-22
2009-05-29
Thanks in advance
Paddy
Subject
Written By
Posted
select dates in a month that fall on a given day of the week
May 22, 2009 09:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.