Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Use of SYSDATE for millisecond timing.
Nope. Since the Oracle DATE datatype only records down to the second, that's all you get with sysdate. You either need to go Java (if 8i) or external.
Dave
<jsicore_at_my-deja.com> wrote in message news:91u311$10u$1_at_nnrp1.deja.com...
> Is there any way to improve the precision (<1 sec.) of SYSDATE?
> I can only perform measurements on SYSDATE down to the second, anything
> less causes rounding to the second.
>
> Thanks.
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Dec 21 2000 - 18:26:26 CST