Re: ???? date-format to get milliseconds from sysdate ????

Nope.
SYSDATE (as returned from the Oracle kernel) only gives the time to the nearest second. You'll have to access the system timer directly.

Chrysalis.

Anton Dischner wrote:
>
> Hi Manfred,
>
> i am not shure,
>
> try select * from v$timer;
>
> Kind regards,
>
> Toni
> In article <5f3jsd$7cc_at_news00.btx.dtag.de>, arkusa_at_t-online.de (Arkusa GbR)
> wrote:
>
> > I need help where to find out the date format or the parameter settings
> > to get the sysdate with milliseconds.
> > Has anyone got an idea where to find information or how to do this?
> >
> > Thanks in advance
> >
> >
> > Manfred Tischendorf
> >
>
> --
> A. Dischner, SGI&AIX sysadmin, Oracle DBA | Don't let friends
> Institut fuer Klinische Chemie | use WinDose
> Klinikum Grosshadern | Just say NO.
> Ludwig Maximilians Universitaet Muenchen, GER |
> Marchioninistr.15 81366 Muenchen 49-89-70953202 |
  Received on Thu Mar 06 1997 - 00:00:00 CST