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.

• Next in forum: Re: Selecting last date
• Prev in forum: Re: Crosstab. 2 totals ?
• Thread view: Re: Selecting last date

[Reply to this message]