At 14:56 +0200 12/27/02, Patrascu Eugeniu wrote:
Hi,
I have a problem calculating birthdays in sql. Here goes my setup:
I have a database that contains the bithdays of a number of people, and I want to know when there birthday is to congratulate them.
The thing is that I want to now that a day before their birthday. Therefore I need a way to do that, and I do not know how to do it, so I am asking on this list, maybe there is someone that can tell me how.
Compare the MONTH() and DAYOFMONTH() values of your birthday column to the MONTH() and DAYOFMONTH() values for tomorrow's date, which you can calculate using CURDATE() and DATE_ADD(). Something like this: SET @tomorrow = DATE_ADD(CURDATE(),INTERVAL 1 DAY); SELECT * FROM tbl_name WHERE MONTH(birth) = MONTH(@tomorrow) AND DAYOFMONTH(birth) = DAYOFMONTH(@tomorrow);
Regards, Patrascu Eugeniu
sql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
