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';

instead of subtracting 1 day, subtract either 16 or 32 hours (which one is correct temporarily escapes me)

Hi, that’s perfect, thank you so much, I got really hung up on this one. Appreciated greatly.