(07-13-2018, 03:47 PM)skunkbad Wrote: PHP Code:
AND modified > ( NOW() - INTERVAL 1 HOUR )
Ah interesting, I've always used DATE_SUB("2017-06-15", INTERVAL 10 DAY) function, so didn't think the simple minus or plus wouldn't work.
For some reason I've always preferred setting exact expiry time, not current timestamp then trying to work backwards from there, I guess both ways have some shortcomgins and some advantages.