Re: newbie help
| From: | CC Zona | Date: | Mon, 26 Mar 2001 17:58:59 +0000 |
| Subject: | Re: newbie help | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-7840@lists.php.net to get a copy of this message | ||
In article <B6E4B9E9.10F3E%m@threezero.co.uk>,
m@threezero.co.uk (Matt Coyne) wrote:
> now does anyone know about getting ages from dates of birth (previous post
> of mine) and also searching by age group when you only have dates of birth
> in the table!!
See the MySQL manual's chapter on date/time functions for many options.
Personally, I'm a big fan of date_add() and date_sub() since they allow for
using relatively "natural language" intervals like "interval 1 day" or
"interval 3 year" when doing the calcuations. Easier to read ==> easier to
debug (IMO).
--
CC