timestamps working in 9i?

From: Lou <louis.masters_at_log-net.com>
Date: 8 Feb 2002 11:31:10 -0800
Message-ID: <13615bc6.0202081131.15b4adb8@posting.google.com>

I have been trying for a few days now to get timestamps working on Ora 9.0.1 on Win2k. It seems the precision of the datatype is off. For example, if I do a general select:

select systimestamp from dual;

I get:

SYSTIMESTAMP

---

08-FEB-02 02.22.31.000001 PM -05:00 It took me a while, but I found out that behind the scenes, Oracle is rounding the timestamp to 6 chars (default). So, the 'real' timestamp value is:

08-FEB-02 02.22.31.000000995 PM -05:00 for example.

Can someone explain to me what is going on? How do I get timestamps to work like they do in the Oracle 9i docs? Is this something to do with the OS's time precision?

Help!

Thanks,
Lou Received on Fri Feb 08 2002 - 13:31:10 CST