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 -> does datatype DATE stores fractions of seconds (Oracle8i)?

does datatype DATE stores fractions of seconds (Oracle8i)?

From: Carsten Jacobs <carsten.jacobs_at_tool42.com>
Date: Tue, 28 Mar 2000 18:14:23 +0200
Message-ID: <38E0DA5F.1C428AC8@tool42.com> 






For some reason I have to migrate from Sybase to Oracle. Now it looks
like that Oracles datatype DATE


doesn't have fractions of seconds like Sybase DATETIME (04-03-2000
09:08:12:587). Is there a way to store


fractions or do I have to use a workaround like storing the fractions in
a separate int-column (which is not nice) ?



Any help is welcome! Thanks



Carsten







Received on Tue Mar 28 2000 - 10:14:23 CST












Original text of this message













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