Retrieve database records by date field?

Question

How do I recover users recorded in a database table by the dt_birth field through two values representing the minimum and maximum age of the users that will be returned, the minimum and maximum age does not always come together can-if you specify only the minimum age, or only the maximum age. Is subquery necessary? Note: the database is mysql.

Basically this would be the query (where 18 and 30 are the age limits) the date of birth this in the American format YYYY/MM/DD the Where clause is just an example, it does not work.

SELECT nome, dt_nascimento FROM usuario WHERE dt_nascimento > 18 AND dt_nascimento < 30;

Answer 1

From what I understand you can just do the following:

select nome, dt_nascimento 
from tbl_tabela1
where TIMESTAMPDIFF(YEAR, dt_nascimento , CURDATE()) between 18 and 30

I am assuming that the date is stored in the database in the appropriate format. If not, you can always convert (CAST) to date or datetime.

TIMESTAMPDIFF can also return the difference between two dates in DAYS or MONTHS, just replace YEAR by MONTH or DAY

Answer 2

Add 18 years and 30 years to date of birth and compare to current date .

SELECT nome, dt_nascimento 
FROM tbl_tabela1 
WHERE DATE_ADD(dt_nascimento,INTERVAL 18 YEAR) <= CURDATE()
AND DATE_ADD(dt_nascimento,INTERVAL 30 YEAR) >= CURDATE();  

If dt_birth + 18 years is <= the current date is because you are over 18 years old.
If dt_birth + 30 years is >= the current date is because it is less than 30 years old.