Re: oracle sequence numbers

From: Bob Hairgrove <rhairgroveNoSpam_at_Pleasebigfoot.com>
Date: Fri, 17 Jan 2003 20:20:33 GMT
Message-ID: <3e286478.877301@news.webshuttle.ch>

On Fri, 17 Jan 2003 11:07:58 -0600, Pablo Sanchez <pablo_at_dev.null> wrote:

>Ahm, I was looking for a specific DBMS though. Can you list a
>commercially available DBMS that has this support?

DB2, for one.

Even lowly MS-Access has a primitive kind of timestamp, but they call it DATETIME. If you look at the result set from the ODBC call to SQLGetTypeInfo() for Access, you'll see that it has DATETIME with the SQL type listed as SQL_TYPE_TIMESTAMP (code 93) with precision of 19, min_scale and max_scale both == 0. Also, you can successfully bind C-type TIMESTAMP_STRUCT variables to DATETIME columns.

I'm sure much the same is true of Oracle et al.

Bob Hairgrove
rhairgroveNoSpam_at_Pleasebigfoot.com Received on Fri Jan 17 2003 - 14:20:33 CST