Calculate Date of Birth?
Posted: Fri Mar 26, 2010 10:42 am
I have database in mysql and has a table name "act" contains four fields as
id(int), date_birth(date), date_close(date), age(date)
1 03-09-1987 20-03-2010
2 05-06-1989 20-03-2010
I want that set the query for age field like that it takes date from field 'date_close' and subtract it from 'date_birth' and display in age field.
How it is possible, please help?
Adil
id(int), date_birth(date), date_close(date), age(date)
1 03-09-1987 20-03-2010
2 05-06-1989 20-03-2010
I want that set the query for age field like that it takes date from field 'date_close' and subtract it from 'date_birth' and display in age field.
How it is possible, please help?
Adil