Hello.
I need to get all fields from a mySQL database where the mySQL timestamp shows the record as over a week old.
My guess was this:
SELECT *
FROM `old`
WHERE oldtime <= ( NOW( ) -00000007000000 );
However, considering this timestamp, 20041203174855, gives something like 96 days.
How can i do this?
Thanks!