Posted by --CELKO-- on 12/31/06 14:03

>> In ANSI SQL, getdate() should be CURRENT_TIMESTAMP. Whether dateadd (my query mistakely had "datedadd" I see now) is in ANSI SQL, I don't know, nor do I know about date aritmethics in general in ANSI SQL. <<

It is not ANSI/ISO. Temporal math in Standard has infixed operators +
and - with temporal unit declarations, EXTRACT() and oher functions
that are very different from the Sybase/SQL Server "code museum"
function calls. DB2 and Oracle 10 now both have the proper syntax. I
thnk that Mimer and Solid are also up to standards.

[Back to original message]