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

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.

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