Re: delete time related data inside a table within 1 hour
| From: | Mark-Walter at t-online dot de | Date: | Tue, 26 Oct 2004 19:35:27 +0000 |
| Subject: | Re: delete time related data inside a table within 1 hour | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37035@lists.php.net to get a copy of this message | ||
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 use INTERVAL 1 HOUR it
deletes it immediately.
The used column is date and time related 2004-10-24 07:42:34 and
work's fine while using INTERVAL -1 DAY.
--
Best Regards,
Mark