mardi 8 septembre 2020

Why does this DATE operator not work on my query?

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