Re: [PHP] Age from birthdate?

[Mike Migurski]

>Lastly, where in the world did you get "pedant"?  word for the day or
>something? :-D Thats a real unusual word for normal everyday use, unless
>you were trying to act pedant?? :-

The correct adverbial form is "pedantically"

;)

-
michal migurski- contact info and pgp key:
sf/cahttp://mike.teczno.com/contact.html

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Age from birthdate?

[Ryan A]

Nope, am a newbie here and I myself admit my grasp of php aint aint the
best, but dont you think something as "interesting" as this should be
discusses offlist?
(And yes, I do see the irony of cc'ing this to the list...)

Lastly, where in the world did you get "pedant"?  word for the day or
something? :-D Thats a real unusual word for normal everyday use, unless you
were trying to act pedant?? :-

Cheers,
-Ryan


>Oh, you're such a pedant.

On Thursday 23 Oct 2003 9:08 pm, Ryan A wrote:
> Now HERES a good PHP related thread thats been going on for around 2
> days...:-D
>
> >Yes, but think about all the presents, hangovers, etc. they miss.
>
> On Thursday 23 Oct 2003 2:12 am, Mike Migurski wrote:
> > >> >I do wonder what the rule for those born on Feb 29'th.  Do they
> > >> >celebrate they're birthday before or after it on non leap years?
> > >>
> > >>Neither.  They celebrate it on Feb 29th.  So while we age every
> > >> year, they only age once every four.  Make sense?
> > >
> > >So their life expectancy is only ~19 years? I'd hate to be born on that
> > >day :)
> >
> > I dunno, a housemate of mine is thrilled to be turning just 9 years old
> > this year. :D
> >
> > -
> > michal migurski- contact info and pgp key:
> > sf/cahttp://mike.teczno.com/contact.html

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Age from birthdate?

[Nicholas Robinson]

Oh, you're such a pedant.

On Thursday 23 Oct 2003 9:08 pm, Ryan A wrote:
> Now HERES a good PHP related thread thats been going on for around 2
> days...:-D
>
> >Yes, but think about all the presents, hangovers, etc. they miss.
>
> On Thursday 23 Oct 2003 2:12 am, Mike Migurski wrote:
> > >> >I do wonder what the rule for those born on Feb 29'th.  Do they
> > >> >celebrate they're birthday before or after it on non leap years?
> > >>
> > >>Neither.  They celebrate it on Feb 29th.  So while we age every
> > >> year, they only age once every four.  Make sense?
> > >
> > >So their life expectancy is only ~19 years? I'd hate to be born on that
> > >day :)
> >
> > I dunno, a housemate of mine is thrilled to be turning just 9 years old
> > this year. :D
> >
> > -
> > michal migurski- contact info and pgp key:
> > sf/cahttp://mike.teczno.com/contact.html

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Age from birthdate?

[Ryan A]

Now HERES a good PHP related thread thats been going on for around 2
days...:-D


>Yes, but think about all the presents, hangovers, etc. they miss.


On Thursday 23 Oct 2003 2:12 am, Mike Migurski wrote:
> >> >I do wonder what the rule for those born on Feb 29'th.  Do they
> >> >celebrate they're birthday before or after it on non leap years?
> >>
> >>Neither.  They celebrate it on Feb 29th.  So while we age every
> >> year, they only age once every four.  Make sense?
> >
> >So their life expectancy is only ~19 years? I'd hate to be born on that
> >day :)
>
> I dunno, a housemate of mine is thrilled to be turning just 9 years old
> this year. :D
>
> -
> michal migurski- contact info and pgp key:
> sf/cahttp://mike.teczno.com/contact.html

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Age from birthdate?

[Nicholas Robinson]

Yes, but think about all the presents, hangovers, etc. they miss.


On Thursday 23 Oct 2003 2:12 am, Mike Migurski wrote:
> >> >I do wonder what the rule for those born on Feb 29'th.  Do they
> >> >celebrate they're birthday before or after it on non leap years?
> >>
> >>Neither.  They celebrate it on Feb 29th.  So while we age every
> >> year, they only age once every four.  Make sense?
> >
> >So their life expectancy is only ~19 years? I'd hate to be born on that
> >day :)
>
> I dunno, a housemate of mine is thrilled to be turning just 9 years old
> this year. :D
>
> -
> michal migurski- contact info and pgp key:
> sf/cahttp://mike.teczno.com/contact.html

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Age from birthdate?

[Mike Migurski]

>> >I do wonder what the rule for those born on Feb 29'th.  Do they
>> >celebrate they're birthday before or after it on non leap years?
>> >
>> >
>>Neither.  They celebrate it on Feb 29th.  So while we age every
>> year, they only age once every four.  Make sense?
>
>So their life expectancy is only ~19 years? I'd hate to be born on that
>day :)

I dunno, a housemate of mine is thrilled to be turning just 9 years old
this year. :D

-
michal migurski- contact info and pgp key:
sf/cahttp://mike.teczno.com/contact.html

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Age from birthdate?

[Martin Towell]

> * Thus wrote Ashley M. Kirchner ([EMAIL PROTECTED]):
> > Curt Zirzow wrote:
> > 
> > >I do wonder what the rule for those born on Feb 29'th.  Do they
> > >celebrate they're birthday before or after it on non leap years?
> > > 
> > >
> >Neither.  They celebrate it on Feb 29th.  So while we age every 
> > year, they only age once every four.  Make sense?
> 
> So their life expectancy is only ~19 years? I'd hate to be born on
> that day :)

And they'd look old for their age too. A 5 year old would look 20 ;-/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Age from birthdate?

[Curt Zirzow]

* Thus wrote Ashley M. Kirchner ([EMAIL PROTECTED]):
> Curt Zirzow wrote:
> 
> >I do wonder what the rule for those born on Feb 29'th.  Do they
> >celebrate they're birthday before or after it on non leap years?
> > 
> >
>Neither.  They celebrate it on Feb 29th.  So while we age every 
> year, they only age once every four.  Make sense?

So their life expectancy is only ~19 years? I'd hate to be born on
that day :)


Curt
-- 
"My PHP key is worn out"

  PHP List stats since 1997: 
  http://zirzow.dyndns.org/html/mlists/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Age from birthdate?

[Ashley M. Kirchner]

Curt Zirzow wrote:

I do wonder what the rule for those born on Feb 29'th.  Do they
celebrate they're birthday before or after it on non leap years?
 

   Neither.  They celebrate it on Feb 29th.  So while we age every 
year, they only age once every four.  Make sense?

--
H| I haven't lost my mind; it's backed up on tape somewhere.
 +
 Ashley M. Kirchner    .   303.442.6410 x130
 IT Director / SysAdmin / WebSmith . 800.441.3873 x130
 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave. #6
 http://www.pcraft.com . .  ..   Boulder, CO 80303, U.S.A. 

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Age from birthdate?

[Curt Zirzow]

* Thus wrote John W. Holmes ([EMAIL PROTECTED]):
> DvDmanDT wrote:
> 
> >How would I get the age of someone if I store the birthdate in a date 
> >field?
> >I just realized FLOOR((UNIX_TIMESTAMP(NOW()) -
> >UNIX_TIMESTAMP(birthdate))/60/60/24/365.25)  wont work for persons born
> >before 1970... :p I must get the current age in years, and I must be able 
> >to
> >select by age... :p Any ideas?
> 
> YEAR(CURRENT_DATE) - YEAR(dob) - 
> (IF(DAYOFYEAR(dob)>DAYOFYEAR(CURRENT_DATE),1,0)) AS age

I do wonder what the rule for those born on Feb 29'th.  Do they
celebrate they're birthday before or after it on non leap years?


Curt
-- 
"My PHP key is worn out"

  PHP List stats since 1997: 
  http://zirzow.dyndns.org/html/mlists/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Age from birthdate?

[John W. Holmes]

DvDmanDT wrote:

How would I get the age of someone if I store the birthdate in a date field?
I just realized FLOOR((UNIX_TIMESTAMP(NOW()) -
UNIX_TIMESTAMP(birthdate))/60/60/24/365.25)  wont work for persons born
before 1970... :p I must get the current age in years, and I must be able to
select by age... :p Any ideas?
YEAR(CURRENT_DATE) - YEAR(dob) - 
(IF(DAYOFYEAR(dob)>DAYOFYEAR(CURRENT_DATE),1,0)) AS age

will work for MySQL, where "dob" is your DATE date of birth column.

--
---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals – www.phparch.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Age from birthdate?

[Jason Wong]

On Thursday 23 October 2003 00:31, DvDmanDT wrote:
> How would I get the age of someone if I store the birthdate in a date
> field? I just realized FLOOR((UNIX_TIMESTAMP(NOW()) -
> UNIX_TIMESTAMP(birthdate))/60/60/24/365.25)  wont work for persons born
> before 1970... :p I must get the current age in years, and I must be able
> to select by age... :p Any ideas?

If using MySQL:

  SELECT FROM_DAYS((TO_DAYS(NOW()) - TO_DAYS(dob))) as age

or something.

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
--
/*
Oh, yeah, life goes on, long after the thrill of livin' is gone.
-- John Cougar, "Jack and Diane"
*/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Age from birthdate?

[Eugene Lee]

On Wed, Oct 22, 2003 at 06:31:21PM +0200, DvDmanDT wrote:
: 
: How would I get the age of someone if I store the birthdate in a date field?
: I just realized FLOOR((UNIX_TIMESTAMP(NOW()) -
: UNIX_TIMESTAMP(birthdate))/60/60/24/365.25)  wont work for persons born
: before 1970... :p I must get the current age in years, and I must be able to
: select by age... :p Any ideas?

Determining someone's age based on Unix timestamps was discussed earlier
this month.  Check the archives for a working function.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php