Re: milliseconds...

From: wayne <no_at_email.please.com>
Date: 08 Jun 2001 01:34:37 GMT
Message-ID: <9fpa3d$20k@dispatch.concentric.net>

> is it possible to store dates in Oracle with a millisecond precision ?

Not natively... The oracle docs (Oracle 8.1.6) say the following about the date data type: "Date data is stored in fixed-length fields of seven bytes each, corresponding to century, year, month, day, hour, minute, and second."

Now, you probably can store the time in a DATE and the milliseconds in a separate number(3) field.

Can you get SYSDATE to return the time with milliseconds included? Probably not. You would have to provide your own milliseconds. Received on Thu Jun 07 2001 - 20:34:37 CDT