Re: MILISECONDS IN ORACLE

From: <manager43_at_my-deja.com>
Date: Thu, 27 May 1999 12:23:23 GMT
Message-ID: <7ijdfq$hrs$1@nnrp1.deja.com>

Hi,

look for features of the "Time Series Cartridge".

Vladimir

In article <7iceo0$uu3$1_at_news.firstcom.cl>, "Vitoco" <vaucanir_at_solex.cl> wrote:
> 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
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 27 1999 - 07:23:23 CDT