timestamp resolution

From: Johan Eriksson <valpis_at_gmail.com>
Date: Thu, 27 Sep 2007 08:53:48 +0200
Message-ID: <6c133d8a0709262353v3bf2db36q9615195d53071044@mail.gmail.com>

Hi all

My environment is Red Hat 4, 64 bit and oracle 10.2.0.2 64bit

A newly created databases gives me some trouble. This query and output is from another database

select current_timestamp from dual;

CURRENT_TIMESTAMP

---

27-SEP-07 08.41.39.980750 AM +02:00 all fine and dandy, if rerun all the decimals are changed, but running on the new database gives me
27-SEP-07 08.41.39.980000 AM +02:00
and it is only the 2 first decimals that are changed, the rest is always zeros.

Anyone who could advice on what could trigger this?

/johan

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 27 2007 - 01:53:48 CDT