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 <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]