Time fraction(6) with Oracle 9i on Windows NT

From: Eugene Petrov <e_petrov_at_altaee.com>
Date: Thu, 16 Sep 2004 17:41:44 +0300
Message-ID: <1095345705.24837@moxa.united.net.ua>

Can Oracle 9i generate microseconds for timestamp fields on Windows NT?

I have a table with one timestamp field. Several inserts of CURRENT time gave following result:

  2004-09-15-16.47.11.154000
  2004-09-15-16.47.11.186000
  2004-09-15-16.47.11.201000
  2004-09-15-16.47.11.232000

It looks like Oracle can only generate 3 fractional digits. We used the default options while installing Oracle 9i.

May be there is some options that can affect this restriction? Some other RDBMS can generate the fraction(6). For example, DB2 would generate following:

  2004-09-15-16.47.11.154001
  2004-09-15-16.47.11.186002
  2004-09-15-16.47.11.201003
  2004-09-15-16.47.11.232004

It appears that DB2 uses a static counter for generations microseconds. It is a normal approach with Windows (that has problems with fractions more then 3 digits!).

Theoretically, We could generate fraction(6) manually and insert them in DB, but the system we migrate on Oracle is too big. We cannot replace all 'insert CURRENT' with the code generating correct timestamp fraction(6)!

Who solved such problems, please, share your knowledge!

Thanks in advance,
Eugene Petrov. Received on Thu Sep 16 2004 - 09:41:44 CDT