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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 28 Mar 2000 18:54:33 +0200
Message-ID: <954263469.20245.0.pluto.d4ee154e@news.demon.nl>

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
>
>

The Oracle date datetype doesn't store fractions of a second. There's no way to store fractions of a second other than to store the entire column as varchar2 and for all comparisons etc. convert.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Mar 28 2000 - 10:54:33 CST