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

No comments posted yet

Your Answer:

Login to answer
58 Like 40 Dislike
Previous forums Next forums
Other forums

MS are the best!!!
Visit http://www.microsoft.com/australia/windows/default.aspx?h=watch-a-demo and click the massive '

Only add new information from XML to MySQL
What I am doing, is taking a xml file, and adding the values to a database. However, what I want to

foreach loop, assistance request
I would like some guidance on the usage of foreach as I try to parse through a large database and wh

Join Query Help
Hi all,

I am having problems with the below code, which we shall call 'my first join query'!

strtotime issue
Hey all,

I'm playing around with some code, and basically the idea is:

Person changes

Inserting the current date/time while submitting the forum
What do I need to add below to update the current date/time? I have a field in the database called d

Need help-Error istream header declaration
Hi Everyone ,

I am having issue with istream declaration. I am new to C programming.
can a

Checking if variable is 0 as opposed to NULL/Empty...
I'm trying to write some code that will retrieve a user's access level from my database and if it do

mysql VARCHAR acting like INT
Hi, All.

I have a table that contains a varchar(10) column named weird_field. In this column

Help with forum quoting?
Hi im working on a forum and I have alomost finished it but i want a user quote system like twitter

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash