Re: Milliseconds in Oracle?

From: MotoX <rat_at_tat.a-tat.com>
Date: Tue, 7 Jul 1998 10:41:31 +0100
Message-ID: <899804410.16172.0.nnrp-09.c2de712e@news.demon.co.uk>

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_at_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
>
>
Received on Tue Jul 07 1998 - 04:41:31 CDT