RE: Time precision

From: Jamadagni, Rajendra <rajendra.jamadagni_at_espn.com>
Date: Tue, 27 Jun 2000 09:39:54 -0400
Message-Id: <10541.110529@fatcity.com>

There is no millisecond in Oracle let along microsecond, at-least usable by users. Oracle date is reported accurate to seconds only. Of course dbms_utility.get_time gets you to 1/100th of a second from an arbitrary epoch.

BTW it would be possible to employ external procedures and tap into OS supplied date functions to retrieve dates, and that I assume will be even more precise.

HTH
Raj

---

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art ! Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. Received on Tue Jun 27 2000 - 08:39:54 CDT