HI
Can anyone help with a statement to select all rows from a table where the value of a column is earlier than today's date.
The date is stored as(for example) Monday 1 March %W %e %M
I was hoping something like this would work:
SELECT * FROM `table` WHERE DATE_FORMAT(dispatchdate, '%W %e %M') < NOW()-INTERVAL 1 DAY
Thanks
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.