From: "Spencer" <spencerp@swbell.net>
Newsgroups: comp.databases.oracle
References: <3A969E4E.51944584@hotmail.com>
Subject: Re: milliseconds
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <UkYn6.691$RU5.5649@nnrp1.sbc.net>
Date: Fri, 2 Mar 2001 20:07:36 -0600
NNTP-Posting-Host: 208.190.213.153
X-Complaints-To: abuse@swbell.net
X-Trace: nnrp1.sbc.net 983585204 208.190.213.153 (Fri, 02 Mar 2001 20:06:44 CST)
NNTP-Posting-Date: Fri, 02 Mar 2001 20:06:44 CST
Organization: SBC Internet Services


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@hotmail.com> wrote in message
news:3A969E4E.51944584@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,
>
>