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

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 29 Mar 2000 18:39:51 +0800
Message-ID: <38E1DD77.3362@yahoo.com>

Carsten Jacobs wrote:
>
> 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
>
> ---------------------------------------------------------------
>
> Name: carsten.jacobs.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Visitenkarte für Carsten Jacobs

dbms_utility.get_time gives 100th's of a second but they are not explicitly related to a date as such.

HTH
--

---

Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse Received on Wed Mar 29 2000 - 04:39:51 CST