|
02-21-2005, 09:51 AM
|
#1 |
|
Junior Member
Join Date: Feb 2005
Posts: 1
|
Formula problem
lpad(floor((to_days(now())-to_days(table1.field9))/365.25),2,'0')
the above formula is to calcuate age based on birthdate, it does but it is 1 year shy of correct date, and ideas why? I also would like to see if I can calcuate age as of a set date. I mean if you are 21 by July 31 I want your age shown as 22 if after July 21 ages is 21 |
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Little Problem | aran384 | PHP | 2 | 12-14-2004 04:58 AM |
| Mysql ended / daemon broken problem | southamptonfc | General | 0 | 11-30-2004 10:29 AM |
| Complex Aggregate problem (AVG) | WoG | SQL syntax | 1 | 11-24-2004 08:45 AM |
| Table access problem | hillxy | General | 1 | 10-20-2004 01:48 PM |
| 1.7 MySQL Information Sources | Administrator | Documentation | 8 | 06-08-2004 02:58 AM |
