Age field and date field

[saidbakr]

Hello,

I have a table has some fields like the following:

The table name is users

id* int autoincrement
join_date datetime
age_year int
age_month int

id =>1
join_date=>2007-05-11 00:00:00
age_year=> 19
age_month=> 0

Suppose after two years from the join_date 2007-05-11 i.e 2009-05-11, I'd like to select all members of age_year > 20.

How can I write a SQL statement's query to return the previous row as a part results?

[leatherback]

I would not store the age, but I would just store the year of birth / date of birth, as that is time independent, which would solve your problem straight away.

[saidbakr]

Hello,

Regarding my initial post about this request, We can get a record set of all members with age greater than defined age, let we say 20 as follows:

SELECT id, age_year+(YEAR(NOW()) - YEAR(join_date)) AS cur_age FROM
users WHERE
age_year+(YEAR(NOW()) - YEAR(join_date)) > (YEAR(NOW()) - YEAR(join_date))+20

This query will add the number of years added to age_year value according to the current year value.

[leatherback]

fall=>setting up for

:d