Re: millisecond in date field

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 22 Aug 1999 11:46:11 +0800
Message-ID: <37BF7283.5A3D@yahoo.com>

Norris wrote:
>
> Will it be enhanced in the coming release?
>
> Breno de Avellar Gomes <brenogomes_at_ieee.org> wrote:
> > according to product documentation Oarcle stores time down to seconds.
>
> > Norris wrote:
>
> >> Is it possible to save and display millisecond in a date field?
> >>
> >> --
> >> =============================================================
> >> Opinions are mine and do not necessarily reflect those of the
> >> Corporation.
> >> http://www.ntfaq.com
> >> http://www.jsiinc.com/reghack.htm
> >> http://www.orafaq.org
> >> http://www.oconnell.net/Sybase_FAQ
> >> =============================================================
>
> > --
> > Breno de Avellar Gomes
> > DBMS Developer
>
> > Arquivo-Sistemas de Bases de Dados
> > P. O. Box 5006
> > 4017-001 Porto
> > Portugal
>
> > brenogomes_at_ieee.org
> > Cellular: +351 931 7383469
> > ICQ # 35567342
>
> > Toll free fax and voice recorder from USA
> > 1-888-EXCITE2 extension 291-303-8152
>
> --
> =============================================================
> Opinions are mine and do not necessarily reflect those of the
> Corporation.
> http://www.ntfaq.com
> http://www.jsiinc.com/reghack.htm
> http://www.orafaq.org
> http://www.oconnell.net/Sybase_FAQ
> =============================================================

Unlikely...

DATE's are dates...if you're looking for something to provide uniqueness, then use a sequence, if you want "milliseconds" then have a sequence that wraps at 1000 and concatenate it to a date...

dbms_utlity.get_time returns 100ths of a second from an arbitrary point in the past - but this can reset as you bounce the database.

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sat Aug 21 1999 - 22:46:11 CDT