Xref: alice comp.databases.oracle.server:24129
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!btnet-peer!btnet!dispose.news.demon.net!demon!news.demon.co.uk!demon!pmcgettigan.demon.co.uk!not-for-mail
From: "MotoX" <rat@tat.a-tat.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Milliseconds in Oracle?
Date: Tue, 7 Jul 1998 10:41:31 +0100
Message-ID: <899804410.16172.0.nnrp-09.c2de712e@news.demon.co.uk>
References: <6nrr5s$3la$1@birch.prod.itd.earthlink.net>
X-Trace: news.demon.co.uk 899804410 nnrp-09:16172 NO-IDENT pmcgettigan.demon.co.uk:194.222.113.46
X-Complaints-To: abuse@demon.net
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Lines: 27

No, it's seconds precise.

Roll your own: store milliseconds in numeric columns and either sum it with
a real date delta (i.e., store it all in one column) or store it in two
columns (DATE + a NUMERIC). Maybe combine then into a new TYPE in Oracle8,
if that's what you're running.

MotoX

John M. Reed Jr. wrote in message
<6nrr5s$3la$1@birch.prod.itd.earthlink.net>...
>Hello All,
>
>I am in the process of converting a Sybase database to Oracle, for a
client,
>and have a slight delimma.  Does Oracle support milliseconds in the native
>DATE datatype?  You see, Sybase does.  If not, any suggestions?  Some of
>their data is time sensitive, down to the millisecond.
>
>Thanks in advance,
>
>John M. Reed Jr.
>Oracle DBA / Dev 2K Programmer
>
>