Re: Milliseconds Oracle 7.3

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 24 Nov 2000 19:12:08 +0100
Message-ID: <8vmsvl$57gg3$4@ID-62141.news.dfncis.de>

"Anders Kjær" <akj_at_fibervisions.dk> wrote in message news:8vl8o7$pq9$1_at_news.inet.tele.dk...
> 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
>
>
>
>

It is not possible.
There is a dbms_utility.get_time function but this doesn't return the sysdate, it returns the number of millisecs since Oracle started.

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Nov 24 2000 - 12:12:08 CST