Re: Unique Date/Time

From: <stevec_at_zimmer.csufresno.edu>
Date: 1998/04/07
Message-ID: <6ge5gm$7d3$1@nnrp1.dejanews.com>#1/1

The function DBMS_Utility.Get_Time returns a number that is incremented by one every hundredth of a second. I'm not sure if it can be converted to a real date and time--I have only used it to compute elapsed time between two events. Note that it can be a negative number, too.

In article <3529DEE2.4F2B1994_at_kiruna.se>, Christer Holmdahl <christer_at_kiruna.se> wrote:
>
> Hi!
> I'm trying to create a unique value by using TO_CHAR(SYSDATE,
> 'YY-MM-DD:SSSSS').
> The problem is that I must include fractions of a second. Do you have
> any solutions?
>
> Please send personal reply to:
>
> christer_at_kiruna.se
>
> Thanks in advance!
>
> /Christer
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Apr 07 1998 - 00:00:00 CDT