Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating IDs subsequently
Originally posted by Ed Prochak
> If you think the DATE data type only contains the date information and
> not the time, then you are mistaken. The DATE data type records time
> differences down to (IIRC) about 100milliseconds. Or are you saying
> your data is chronologically closer than that?
>
Actually, DATE precision is only down to 1 second, no fractional
seconds. So DATE can only be used as a unique key if you are
generating one record per second, or less frequently than that.
TIMESTAMP goes down to fractional seconds, but Gerd has already said he
doesn't have Oracle 9.
-- Posted via http://dbforums.comReceived on Wed Jul 23 2003 - 08:50:23 CDT