delete time related data inside a table within 1 hour
| From: | Mark-Walter at t-online dot de | Date: | Mon, 25 Oct 2004 20:00:36 +0000 |
| Subject: | delete time related data inside a table within 1 hour | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37013@lists.php.net to get a copy of this message | ||
Hello,
to delete old entries within 1 one day I use this:
$sql = ("DELETE FROM orders WHERE time_date < DATE_ADD(NOW(), INTERVAL
-1 DAY)");
Now I would like to delete within a timeframe of 1 hour.
But when I change the above statement to 1 hour or -1 hour it deletes
immediately.
Maybe someone could help me at this point.
--
Best Regards,
Mark