MySQL Forums :: Newbie :: select dates in a month that fall on a given day of the week


Advanced Search

select dates in a month that fall on a given day of the week
Posted by: Patrick Rooney ()
Date: May 22, 2009 09:35AM

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

Options: ReplyQuote


Subject Written By Posted
select dates in a month that fall on a given day of the week Patrick Rooney 05/22/2009 09:35AM
Re: select dates in a month that fall on a given day of the week Rick James 05/24/2009 09:50AM
Re: select dates in a month that fall on a given day of the week Patrick Rooney 05/28/2009 09:56AM
Re: select dates in a month that fall on a given day of the week Peter Brawley 05/28/2009 10:15AM


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.