MILISECONDS IN ORACLE

From: Vitoco <vaucanir_at_solex.cl>
Date: Mon, 24 May 1999 17:03:27 -0400
Message-ID: <7iceo0$uu3$1@news.firstcom.cl>

Hi

I NEED IMPORT FROM SQL-SERVER 6.5 THE NEXT PART OF A STORE PROCEDURE TO ORACLE 7.3.3.0.0

Select @part1 = DatePart(Millisecond, GetDate())
Select @part2 = DatePart(Minute, GetDate())
Select @part3 = DatePart(Second, GetDate())

Select @X= @part1 * @part2
Select @YZ = @X + @part3

HOW I CAN OBTAIN THE MILISECOND IN ORACLE ?? I HAVE THE NEXT, BUT THE PARAMETER 'SSSSS' ISN'T THE THAT I NEED.

TO_NUMBER(TO_CHAR(SYSDATE, 'SSSSS')) MILSEC,
TO_NUMBER(TO_CHAR(SYSDATE, 'MI')) MIN,
TO_NUMBER(TO_CHAR(SYSDATE, 'SS')) SEC

FROM DUAL THANKS
VICTOR Received on Mon May 24 1999 - 16:03:27 CDT