Re: Milliseconds Oracle 7.3

Anders Kjær wrote:
>
> Hi
>
> Is it possible to insert a date in this format :
> dd-mm-yyyy hh:mm:ss:ms - where ms is milliseconds
>
> I cant get i work.
>
> Regards
> Anders kjaer

No...

dbms_utility.get_time can give 100'ths of the second (but not related to a time as such)...or you can use a java proc (8i+) to get the time from the OS.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

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