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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php