Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Date attribute question
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
![]() |
![]() |