Hi all, the time on MySQL is wrong - I have contacted my host and they said nothing they can do. So when I need to add the date I have to use DATE_ADD(NOW(), INTERVAL 8 HOUR). However, I now need to select all records older than one day but obviously I’m not getting the correct results as the time is wrong, so what can I do to advance the time by eight hours?
SELECT * FROM application_order WHERE date_purchased < DATE_SUB(date_purchased, INTERVAL 1 DAY) AND order_processed = '0';