Re: date and time?

From: Roger Snowden <snowden_at_NOT.com>
Date: Tue, 12 Jan 1999 03:48:14 GMT
Message-ID: <369AC50E.5E53E87@NOT.com>

No, you cannot. That is, the "date" data type isn't that precise. You can workaround this though, by simply adding another column that contains additional numeric information. You would have to calculate your own value of course, since the sysdate function will only get you the nearest second. But, for storing values, this is a reasonable workaround.

Roger Snowden
Sr. Systems Engineering Specialist
Oracle Corporation
rsnowden_at_NOTus.oracle.com <-- to reply, remove the obvious

txm wrote:
>
> >Also, is it possible to specify a Date field with more precision than
> >seconds? I'd like to go to milliseconds.
>
> I have a same question. Does anybody know about this?
>
> Thanks!
>
> txm
Received on Mon Jan 11 1999 - 21:48:14 CST