Re: How do you get someone's age from DOB?

From: "comp.lang.php" <phillip.s.powell@xxxxxxxxx>
Date: 30 Jan 2006 12:27:17 -0800

I would never have gotten that one. We need a DBA here badly.

Thanx
Phil

Justin Koivisto wrote:
> comp.lang.php wrote:
> > Dangit I thought I could do THIS simple task today and even this is
> > beyond me!! :(
>
> If you're using mysql to get the "birth" field, why not add a field in
> the query:
> FLOOR((CURDATE() - DOB)/10000) AS age
>
> > [code]
> > <?= date(time()) - date(strtotime($result[0]->birth)) ?>
> > [/code]
> >
> > This is completely wrong, but what IS right? I'm stumped!
>
> This depends on how your server handles timestamps. For instance, does
> it support negative ones (before 1970)? I've found using SQL queries to
> calculate age generally work much better as it seems to be consistent
> between platforms/servers.
>
> --
> Justin Koivisto, ZCE - justin@xxxxxxxxx
> http://koivi.com

.

References:
- How do you get someone's age from DOB?
  - From: comp.lang.php
- Re: How do you get someone's age from DOB?
  - From: Justin Koivisto

Prev by Date: Re: How do you get someone's age from DOB?
Next by Date: Re: How do you get someone's age from DOB?
Previous by thread: Re: How do you get someone's age from DOB?
Next by thread: Which installer is better?
Index(es):
- Date
- Thread

Relevant Pages

Re: How do you get someones age from DOB?
... > Dangit I thought I could do THIS simple task today and even this is ... If you're using mysql to get the "birth" field, why not add a field in ... FLOOR- DOB)/10000) AS age ... Justin Koivisto, ZCE - justin@xxxxxxxxx ...
(comp.lang.php)
Re: How do you get someones age from DOB?
... Tried that, always came back with "1" every time, regardless of DOB ... Phil ... Justin Koivisto wrote: ... > unix timestamp of birth date - if on ...
(comp.lang.php)