Re: time stamp granularity issue in Oracle

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: 1997/11/06
Message-ID: <34629537.3BF1454C_at_ntsource.com>#1/1

This is a multi-part message in MIME format.

--------------845A2AE2B0D270D3575A2320
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

[Quoted] Time is presented in hundredths of a second in V$TIMER. Perhaps, something like the following might be useful:

   select to_char(sysdate,'HH24:MI:SS') || '.' || lpad(mod(hsecs,100),2,'0') from v$timer;

L. Tseng wrote:

> Why? Is it too hard to do?
>
> In article <01bce9f9$6bfa1010$54110b87_at_clamagent>,
> Dan Clamage <clamage_at_mime.dw.lucent.com> wrote:
> >> How about I need to get microseconds?
 Can't.
> >> How can I get around this in Oracle?
> >You could build a clock server in C and pass a string via a pipe with the
> >correct time in microseconds, but by the time you get it, it won't be very
> >accurate.
> >> Does anyone know Oracle will increase the DATE granularity in the near
> >future?
> >I'm quite sure they have no plans (or interest) in modifying their internal
> >date format in this direction.
> >-djc
>
> --
> =-=-=-=-=-=-=-=-=-=-=
> Leslie Tseng
> lesliet_at_writeme.com
> =-=-=-=-=-=-=-=-=-=-=

--------------845A2AE2B0D270D3575A2320
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Frank Hubeny
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Frank Hubeny
n:              Hubeny;Frank
adr:            427 East Liberty Drive;;;Wheaton;IL;60187-5510;USA

email;internet: fhubeny_at_ntsource.com
x-mozilla-cpt: ;0
x-mozilla-html: TRUE

version:        2.1
end:            vcard

--------------845A2AE2B0D270D3575A2320-- Received on Thu Nov 06 1997 - 00:00:00 CET