"Ross J. Reedstrom" wrote:
>
> On Fri, Feb 25, 2000 at 06:25:12PM -0600, [EMAIL PROTECTED] wrote:
> > oops, it's "timestamp" now (just name change).
> > BTW, I remember datetime is in sql92. "timestamp" is also in sql92? why
> > "timestamp" is better than "datetime" ? sql99(96) ?
>
> Nope, DATETIME is not an SQL92 type, it's a class of types. Here's a
> snip from the standard:
>
> <datetime type> ::=
> DATE
> | TIME [ <left paren> <time precision> <right paren> ]
> [ WITH TIME ZONE ]
> | TIMESTAMP [ <left paren> <timestamp precision> <right paren> ]
> [ WITH TIME ZONE ]
>
> So the three SQL92 datetime types are DATE, TIME, and TIMESTAMP.
Hi Ross,
Is the standard document you referenced online?
Cheers,
Ed Loehr
************
