|
Posted by Toby A Inkster on 06/23/07 22:44
Bo Wisén wrote:
> In a MYSQL database I have stored when the members were born in the form
> "YYYYMMDD". Now I want a method to select every member who has birthday from
> today and up to 30 days into the future. I would prefer if this could be
> done in a MYSQL query.
You mean it is stored as a string (or integer)? Store it as a proper date.
--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.12-12mdksmp, up 3 days, 2:24.]
A New Look for TobyInkster.co.uk
http://tobyinkster.co.uk/blog/2007/06/22/new-look/
Navigation:
[Reply to this message]
|