Re: timestamp ?(RE: [GENERAL] scheduling table design)

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.

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005