Jana It seems that this won't currently work for me as the database in question is still version 4. Thanks for the help though.
Charlie -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jana Sent: 22 November 2007 11:19 To: [email protected] Subject: Re: [php_mysql] Number of days to a birthday Hi Charlie, Use timestampdiff and from_unixtime function in mysql. Ex: select timestampdiff('DAY', from_unixtime('todays date'), from_unixtime('birthdate')) will returns the number of days. Regards Jana
