Posted by comp.lang.php on 01/30/06 22:27

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@koivi.com
> http://koivi.com

[Back to original message]