Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Milliseconds

Re: Milliseconds

From: Stephen T. Parfitt <steve.parfitt_at_sympatico.ca>
Date: Wed, 12 Sep 2001 14:06:30 -0400
Message-ID: <3B9FA426.83DD8353@sympatico.ca>


I think you would need to call an external function, written in C or assembler, that would call a system function to get the clock to this degree of resolution.

e.g. GetCurrentTime for Windows

Allan Martin wrote:
>
> Hi,
> Does anyone know how to pick up milliseconds in pl/sql.
> I get seconds using the TO_DATE(sysdate, 'format') function, but I really
> need to pick up the milliseconds too.
>
> Thanks in advance,
> Allan Martin
Received on Wed Sep 12 2001 - 13:06:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US