Hi, You're adding 2 different type elements. Try just doing SELECT NOW() + SEC_TO_TIME(6000); and check the result:
mysql> select NOW() + sec_to_time(6000); +---------------------------+ | NOW() + sec_to_time(6000) | +---------------------------+ | 20030821159528 | +---------------------------+ 1 row in set (0.00 sec) For example, minutes=95 !!! Try using DATE_ADD(NOW(), INTERVAL 6000 SECOND) or NOW() + INTERVAL 6000 SECOND On Thu, 2003-08-21 at 13:14, M. Bader wrote: > Hi, > > i'm struggling with updating session expire times in my login table. > > Can you tell me, how to correctly add an amount of seconds (after that > the session expires) to a datetime field? > > when i do the insert for a new login, or an update, the expire field > will alway end up containing zeros > > below are my statements and structure, (MySQL version: 4.0.13) > > > Thanks for any help > > Maik > > INSERT INTO `user_login` ( > `id_kontakt`, > `id_user`, > `session`, > `expire`, > `ip`, > `browser`, > `id_sprache`, > `username`) > VALUES ( > 25, > 39, > '1061461259142493', > (NOW()+SEC_TO_TIME(6000)), > '192.168.0.3', > 'Opera/7.11 (Windows NT 5.0; U) [de]', > 1, > 'maik' > ); > > > UPDATE `user_login` SET `expire` = (NOW()+SEC_TO_TIME(6000)) > WHERE `session` LIKE '1061461259142493'; > > > CREATE TABLE `lok_user_login` ( > `lfdnr` bigint(20) unsigned NOT NULL auto_increment, > `id_kontakt` bigint(20) unsigned NOT NULL default '0', > `id_user` bigint(20) unsigned NOT NULL default '0', > `username` varchar(255) NOT NULL default '', > `session` varchar(255) NOT NULL default '', > `expire` datetime NOT NULL default '0000-00-00 00:00:00', > `ip` varchar(15) NOT NULL default '', > `browser` varchar(255) NOT NULL default '', > `id_sprache` int(10) unsigned NOT NULL default '0', > PRIMARY KEY (`lfdnr`), > UNIQUE KEY `session` (`session`), > FULLTEXT KEY `session2` (`session`) > ) TYPE=MyISAM; > > > -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
