Re: milliseconds

From: Spencer <spencerp_at_swbell.net>
Date: Fri, 2 Mar 2001 20:07:36 -0600
Message-ID: <UkYn6.691$RU5.5649_at_nnrp1.sbc.net>


oracle datatype DATE stores date/time with a resolution only to seconds. if you need to store a date/time value as a column of a table, then you will need to implement your own scheme for handling resolution lower than a second.

"brien goodwin" <unrealk7_at_hotmail.com> wrote in message news:3A969E4E.51944584_at_hotmail.com...
> I am currently running 8.1.6 on AIX and was wondering if there was any
> way for oracle to look at milliseconds, or can it just look at
> hours:minutes:seconds.
> Thanks in advance,
>
>
Received on Sat Mar 03 2001 - 03:07:36 CET

Original text of this message