Can anyone explain to me why during my attempts to select data with a date greater than a specific date it runs the query but I still see dates after 2020-09-01? Due_date is a Date and is stored YYYY-MM-DD on a MySQL DB.
Select
*
from
records
where
job_id = 13582
OR job_id = 13583
OR job_id = 13698
OR job_id = 13699
OR job_id = 13700
OR job_id = 13738
OR job_id = 14133
AND due_date NOT IN (
Select
due_date
from
records
where
due_date > date('2020-09-01')
);
Aucun commentaire:
Enregistrer un commentaire