Re: Performance Measures?

From: David Sisk <davesisk_at_travelin.com>
Date: 1998/02/15
Message-ID: <6c7nj0$su8$1@lal.interserv.com>#1/1

Sysdate does go to milliseconds. Use to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS.000'), I believe.

Dave

Jeff Wyant wrote in message <6br88o$svr$1_at_208.10.2.116>...
>I've been trying to time my stored procedures in Oracle by getting the
>date and time at the start of the stored procedure and then again at the
>end of the stored procedure. The problem I've been running into is that
>the Oracle sysdate only goes to the second and I need to measure in
>milliseconds. Does anyone have a way to perform this type of
>measurement?
>Thanks.
>
Received on Sun Feb 15 1998 - 00:00:00 CST