Re: timestamp ?(RE: [GENERAL] scheduling table design) - Mailing list pgsql-general

"Ross J. Reedstrom" wrote:
>
> On Fri, Feb 25, 2000 at 06:25:12PM -0600, kaiq@realtyideas.com 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