Timestamp precision on Windows 2k Server

From: Scott Goldberg <scott_goldberg_at_hotmail.com>
Date: 17 Jul 2002 09:03:13 -0700
Message-ID: <23153b4f.0207170803.7a8ce945@posting.google.com>

I am working on an application being developed against Oracle 9.2 on Windows 2k Server for deployment on Oracle 9.0.1 on Solaris and hit the following hiccup using timestamps.

Under the windows environment, I never can get a timestamp with precision greater than 3. I.e:
SELECT current_timestamp, current_timestamp(3)FROM dual always yields something like:

CURRENT_TIMESTAMP

---

CURRENT_TIMESTAMP(3)

---

17-JUL-02 12.00.44.392000 PM -04:00
17-JUL-02 12.00.44.392 PM -04:00 Under solaris, I obtain the expected precisions: CURRENT_TIMESTAMP

---

CURRENT_TIMESTAMP(3)

---

17-JUL-02 11.54.04.733216 AM -04:00
17-JUL-02 11.54.04.733 AM -04:00 Is there some setting I can change to obtain the additional precisions under windows?

Thanks

Scott Received on Wed Jul 17 2002 - 11:03:13 CDT