Re: datetime insert using now()

Hi Could you be more specific about the thing that it works only sometimes - when doesn't it work and what happens then. You can check and try the date_add() function but probably the problem is in your query. Dobromir Velev Web Developer http://www.websitepulse.com/ -----Original Message----- From: bill <bill@billtron.com> To: php-db@lists.php.net <php-db@lists.php.net> Date: Tuesday, December 11, 2001 18:08 Subject: [PHP-DB] datetime insert using now() >I'm trying to insert information into a datetime field in a MySQL >database with the following: > >INSERT INTO thisdb (event) VALUES ((now() + 3600); > >But it only works sometimes. Why sometimes? What would be a better way >of doing it? > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > >