Hi again, > From: Diana Soares [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 21, 2003 4:05 PM > | NOW() + sec_to_time(6000) |
That i allready tried, and it's leading to wrong results, as same as > From: Cybot [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 21, 2003 3:42 PM > UPDATE `user_login` SET `expire` = (NOW() + 6000) ^^^^ 'cause 6000 will be interpreted as 60:00, resulting in 0000 Thanks Diana, this one worked: > Try using DATE_ADD(NOW(), INTERVAL 6000 SECOND) Thank you Maik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]