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:[EMAIL PROTECTED]]
Envoye : mardi 11 decembre 2001 16:48
A : [EMAIL PROTECTED]
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: [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]

Reply via email to