| From: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com> |
|---|---|
| To: | "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: timestamp ?(RE: [GENERAL] scheduling table design) |
| Date: | 2000-02-26 00:36:01 |
| Message-ID: | 38B71FF1.4798384E@austin.rr.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Ross J. Reedstrom" wrote:
>
> On Fri, Feb 25, 2000 at 06:25:12PM -0600, kaiq(at)realtyideas(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | esling | 2000-02-26 09:57:57 | Web Site Opportunity for Database Expert |
| Previous Message | kaiq | 2000-02-26 00:25:12 | timestamp ?(RE: [GENERAL] scheduling table design) |