Re: Does DATE datatype support milli-second

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Wed, 17 Mar 1999 21:58:02 +0100
Message-ID: <36f0175e$0$22446@newton>

Dong Tang wrote
>I want to know if Oracle DATE datatype can
>support time interval less 1 second.

No.

However, some other function exists in package dbms_util. I do not recall the name now, but it gets you the milliseconds since the database startup, or something like that. You can use it to calculate time intervals, not to get the milliseconds of the system clock.

If you want to use milliseconds just to get a correct order in your table, then you'd better use an ordered sequence as a primary key instead.

>If you know, please email me at tangd_at_ctcdist.com

Ehhh, this is a newsgroup, right?

Arjan. Received on Wed Mar 17 1999 - 14:58:02 CST