Welcome Guest, Not a member yet? Register   Sign In
how to clear a field in database in x mins?
#8

(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.
Reply


Messages In This Thread
RE: how to clear a field in database in x mins? - by Pertti - 07-14-2018, 01:35 AM



Theme © iAndrew 2016 - Forum software by © MyBB