Re: oracle sequence numbers

From: Pablo Sanchez <pablo_at_dev.null>
Date: Fri, 17 Jan 2003 17:13:56 -0600
Message-ID: <Xns9306A51F9C83Fpingottpingottbah@216.166.71.233>

tonkuma_at_jp.ibm.com (Tokunaga T.) wrote in news:8156d9ae.0301171456.b85146b_at_posting.google.com:

> -- TIMESTAMP -- contains the <primary datetime field>s YEAR, MONTH,
> DAY, HOUR,
> MINUTE, and SECOND.
> (I do not have SQL-92 standard. But, I think they are basically same
> as SQL-99 about timestamp data type.)
>
> I think Oracle's date and timestamp and DB2's date, time and timestamp
> conform to this standard.
>

Thx for the info!

I can't see why anyone would want to use the TIMESTAMP value as defined by SQL-92/-99 for a sequence number when the resolution is no better than a second.

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com

Received on Fri Jan 17 2003 - 17:13:56 CST