MySQL Forums
Forum List  »  Newbie

Finding a DATE
Posted by: rene2006
Date: October 28, 2006 12:58PM


I'am using SQL for the first time since a couple of years... and I ran into a little problem here:
I'm using MYSQL 4.1.15. and I have a table with a list of dates and one specific date <date>. From that list I want to pick the one date that's smaller than my <date>, but closest to it.

Here is an example:

My list:
1, 01.01.1900
2, 01.01.1920
3, 01.01.1940
4, 01.01.1960

If I have the <date> 15.06.1936, the query should pick 01.01.1920.

I am working on this now for about four hours... and can find a solution...

Thanks for any help!!!

Options: ReplyQuote

Written By
Finding a DATE
October 28, 2006 12:58PM
October 29, 2006 11:08AM
October 29, 2006 07:44PM

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.