Re: Does DATE datatype support milli-second

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Thu, 18 Mar 1999 16:07:13 +0800
Message-ID: <36F0B431.47A1@bhp.com.au>

Arjan van Bentem wrote:
>
> 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.

dbms_utility.get_time

and its hundredths not milliseconds..

Cheers
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Thu Mar 18 1999 - 02:07:13 CST