Re: Unique Date/Time

Hello,

I have somewhat similar problem. I have a DATE type field as a primary key field.
When rows are being inserted, SYSDATE is used to fill this field. I fear that more than one insertion can happen within one second and unique constraint will be violated.
Now i'm trying to find a reasonable solution and any help will be welcome.

Thank you,
Igor

Christer Holmdahl 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
 

-- 
Igor Sereda,
ITC, Russia