Date help - fetch dates for Mondays between xxx and yyy?

Posted on 16th Feb 2014 07:03 pm by admin

Does anyone know the best way to do this? I have two dates, say:

2010-01-26 and 2010-05-30

and I want to return the dates of all the Mondays between them:

2010-02-01
2010-02-08
2010-02-15
....etc.

Thanks

Your Answer:

Login to answer

Other forums

SELECT * FROM users WHERE Users are not in Blocked
How do I select all users from users table where there users_id is not stored in the block table

if description does not contain the following words
Hello everyone,

I am parsing a MS Excel (.xls) file and adding it's content to a mySQL databa

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

add text and number image
hi guys ..

ok see i want the user to add their name and pick a number then click get it and i

Inserting 100x and 100y coordinates in mysql table - easy
Is there a way to insert this data into a mysql table named 'map' with the fields: 'x int 3' , 'y in

Rand() help needed
Hi all,

Can someone explain and give me a quick example of how I would go about this?

Images in email problem
I found this script for sending emails, it works but if the email has <img src="image.jp

Is it a good practice to store user info. in sessions?
I am making a user class for my script which stores all the user information in sessions. It takes u

max function question
Hi All
Ihave a table that holds shipment numbers and dates like this

select * from

subtract 1 from value entered in text field
Hi

How do I subtract 1 from the vaue entered into a text field?

Thanks