Re: does datatype DATE stores fractions of seconds (Oracle8i)?

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Tue, 28 Mar 2000 22:48:07 +0200
Message-ID: <8br5rv$juh$1@news.inet.tele.dk>

New datatypes for sub-second time datatypes were taken out of 8.1.6 in the last minute, hopefully they'll be there with 8.1.7.

Cheers,

Finn

Carsten Jacobs <carsten.jacobs_at_tool42.com> wrote in message news:38E0DA5F.1C428AC8_at_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 - 14:48:07 CST