Re: milliseconds...

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 09 Jun 2001 11:56:45 +0100
Message-ID: <3B2200ED.56ACECE9@yahoo.com>

The 'date' format only goes down to seconds. There is a utility called dbms_utility.get_time which is measured in 100th's, but its not a date as such, just a counter.

There are extensions to oracle date/time handling (check the bottom of standard.sql in $ORACLE_HOME/rdbms/admin) - they may be enabled in 9i but I haven't seen it yet

hth
connor

--
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Sat Jun 09 2001 - 05:56:45 CDT