RE: [PHP-DB] datetime insert using now()

BTW, IN SQL ANSI, these functions are standard too? Don't they? - ADDDATE(date1, INTERVAL value UNIT) with UNIT = SECOND, HOUR_SECOND, DAY, and so on... - MOD(value, modulo) and its shortcut value%modulo - Arithmetic operators such as && + || - Is it Better to use <> or != - Is there a recognized format for At least, are they standard in other SQL languages such as oracle, access, postgres, msSql, mSql, etc.. HAS ANSI SQL any validity over SQL languages? How to consult it (ANSI doesn't deliver the document for free) ? Question extensible to: Where to get SQL language comparison charts on their compatibility? Charles Lahlou -----Message d'origine----- De : bill [mailto:bill@billtron.com] Envoye : mardi 11 decembre 2001 16:48 A : php-db@lists.php.net Objet : [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