Hi Martin,
> http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html says
> that's the right format. Are you sure you're storing the time and not
> just the date? I'd wager that it will delete immediately if you are
> only storing the date.
I agree as it is the right format but when I us
[PHP-DB] delete time related data inside a table within 1 hour
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 th
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