Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Date attribute question

Re: Date attribute question

From: Ian Gillman <igillman_at_arinc.com>
Date: 1997/04/08
Message-ID: <ifWG199Q8GA.146@no2.i-way.net>#1/1

In article <E84K86.5A2_at_boss.cs.ohiou.edu>, austby_at_centuryinter.net says...
>
>If a field is defined with the DATE attribute.
>
>Can that field contain a time value with milliseconds (ex. 12/26/1996
>12:12:13.00023) ?
>
>If so what is the syntax for the SELECT statement to display the field
 showing
>milliseconds.
>
>Thanks for any help.
>
>Art
>

I looked into this once and found out that Oracle only stores time down to the nearest second. Unless this situation has changed with 7.3.2.3 (which I doubt very much) the answer to your question is that it is not possible (but it would be a good idea).
TTFN
Ian Received on Tue Apr 08 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US