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

Home -> Community -> Usenet -> c.d.o.server -> Re: ddmmyy hh:mi:ss.??????

Re: ddmmyy hh:mi:ss.??????

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 15 Jul 1998 05:19:05 GMT
Message-ID: <6ohe49$ok92@hendrix.csufresno.edu> 





In article <01bdaf09$afefd9a0$b8cd5997_at_sbaiz>,
Sbaiz <pierluigi.sbaiz_at_elsag.it> wrote:


>Hi,


>


>How I can obtain the microsecond from a DATE field?


>


>Thanks in advance.


>Sbaiz P.





You can't.  The Oracle date data item only contains integer seconds.
You would need to set up a separate numeric column to store fractions
of seconds.



Steve Cosner
Received on Wed Jul 15 1998 - 00:19:05 CDT












Original text of this message













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