Find occurrence of dates inside a given year?

Question

Hi all,

I have a table containing daily dates of working days through several years.

What I would like to have is to be able to choose a date and then find its corresponding date one year later.

An example would be: the date 2000-01-01 and its corresponding date: 2001-01-01. The problem is that 2000-01-01 wasn't a working day and so I will not be able to find it in my table.

Is there any trick for telling mySQL to find a corresponding date in a certain interval that is also actually found in the table?

Am I clear with my question??

I would be happy to hear your opinion about this :-)

Thanks!

Answer 1

Don't think of dates as three numbers (day month year) but instead as one compound number (like a computer uses internally). That way instead of looking for dates in the range say 10/10/2006 to 15/10/2006, you can just look in a number range say 75673 to 75782. (These numbers are made up - don't try to read any meaning in them).

As far as I'm aware, dates are already stored like this in most applications - I'm assuming that SQL is no different.

Rawlyn.

Answer 2

You are clear with the question but I don't have an answer. Sorry.

Answer 3

Micron try this link

http://www.google.co.uk/search?hl=en&q=Find+occurrence+of+dates+inside+a+given+year+in+sql&btnG=Search&meta=