Skip to content
PHP Logo

How can the SQL query be modified to account for the date format in the database (Year-Day-Month) when filtering records by age range?

When filtering records by age range in a database with a date format of Year-Day-Month, the SQL query needs to account for this format to ensure accurate results. One way to do this is by converting the date format in the query itself using the DATE_FORMAT function in MySQL. This function allows you to specify the format of the date column in the query, so it can be compared correctly when filtering records by age range.

php 
// Assuming $minAge and $maxAge are the minimum and maximum ages for filtering
$query = "SELECT * FROM table_name 
          WHERE DATE_FORMAT(date_column, '%Y-%d-%m') 
          BETWEEN DATE_SUB(CURDATE(), INTERVAL $maxAge YEAR) 
          AND DATE_SUB(CURDATE(), INTERVAL $minAge YEAR)";

Related questions