Re: [PHP] Age from birthdate?
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?
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?
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?
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?
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
Re: [PHP] Age from birthdate?
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?
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 mailto:[EMAIL PROTECTED] . 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?
* 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?
* 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?
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?
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