Re: Random & time function?

The system time (i.e. SELECT SYSDATE FROM DUAL) is only to the nearest second:

SQL> select to_char(sysdate,'HH:MI:SS') from dual;

TO_CHAR(SYSDATE,'HH:MI:SS')

You may want to look at the DBMS_UTILITY.GET_TIME function for hundreths. It's header is:

function get_time return number;

• Find out the current time in 100th's of a second.
• Output argukments:
• get_time
• The time is the number of 100th's of a second from some
• arbitrary epoch.

A combination of the two values should do the trick.

Steve Phelan (UK)

Oleg Roshchin wrote in message <6dejuj$avu$1_at_news.netway.at>...
>Hi, all
>
>Does anybody knows how to get system time with milliseconds in PL/SQL?
>I need this to develop RANDOM function.
>
>May be you know any convenient algorithm of RANDOM function?
>
>Sincerely,
>Oleg Roshchin
>
>
>
>
Received on Mon Mar 02 1998 - 00:00:00 CET