http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
Read the comments at the bottom.
DÆVID
> -Original Message-
> From: ESV Media GmbH [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 06, 2006 8:05 AM
> To: mysql@lists.mysql.com
> Subject: Getting
Hello MySQL-User,
i need your help with the following query.
I want to get the next birthdays of my friends, but not only the one of
this year.
So when im in december ( or november ) i want to see the birthdays of
next year too
With my query i only see the birthdays of this year :
SELECT
> I need the birthdays from yesterday, today and the next 4 or 5
birthdays.
You don;t need to manually compute every date component. Try something
like ...
SELECT ...
WHERE DATE_SUB(NOW(),INTERVAL 1 DAY) <= mem.birthday
AND DATE_ADD(NOW(),INTERVAL 5 DAY) >= mem.birthday
ORDER BY mem.bir
Hey, i´ve a problem with getting the next and the actual birthdays.
This my actual birthday sql :
SELECT SQL_CACHE birthday,mem.lname, mem.fname,mem.mem_id FROM members mem
INNER JOIN network net ON (net.mem_id = mem.mem_id AND net.frd_id =1)
WHERE
(( DAYOFYEAR(FROM_UNIXTIME( mem.birthday )) < D
