Re: oracle sequence numbers

From: Pablo Sanchez <pablo_at_dev.null>
Date: Fri, 17 Jan 2003 17:13:56 -0600
Message-ID: <Xns9306A51F9C83Fpingottpingottbah_at_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 Sat Jan 18 2003 - 00:13:56 CET

This message: [ Message body ]
Next message: --CELKO--: "Re: Help finding natural keys"
Previous message: Eric Robinson: "Re: Signal Database"
Maybe in reply to: helen_fearman: "oracle sequence numbers"
In reply to Tokunaga T.: "Re: oracle sequence numbers"
Next in thread: --CELKO--: "Re: Help finding natural keys"
Reply: Tibor Karaszi: "Re: oracle sequence numbers"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message