Eugene Petrov wrote:
> 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.
Did you change the default DISPLAY format from
it's 3 digits to 6?
Same question as to why select sysdate will not display
a time fraction...
--
Regards,
Frank van Bortel
Received on Fri Sep 17 2004 - 04:02:19 CDT
