SQL WHERE clause: where age between x and x?

Question

Possible Duplicate:
How to calculate age (in years) based on Date of Birth and getDate()

Does anyone know how i can set a where clause to say get only those users aged 26-33, by calculating age from date of birth?

I have previously used this to get all users aged below 25 and now i'm just wondering if i could use it to get those aged 26 - 33 or if theres a better way?

AND DOB >= ADDDATE(CURRENT_DATE(), INTERVAL -25 YEAR)

score 1 · Accepted Answer · answered Dec 30 '12 at 02:05

1

AND DOB BETWEEN ADDDATE(CURRENT_DATE(), INTERVAL -33 YEAR) AND ADDDATE(CURRENT_DATE(), INTERVAL -26 YEAR)

(As a suggestion - not tested)

answered Dec 30 '12 at 02:05

Sebas

21,192
9
55
109

i'll try it but i think that would bring up anyone under 33 or 26 not actually do what i want which is only bring up those aged 26 to 33 – Mark Campbell Dec 30 '12 at 02:08
yeah, I think it will do it.. – Sebas Dec 30 '12 at 02:09

SQL WHERE clause: where age between x and x?

1 Answers1