Re: oracle: measurement in microseconds

From: Pascal Ziegler <pascal.ziegler_at_bluewin.ch>
Date: Mon, 25 Aug 2003 10:08:30 +0200
Message-ID: <3f49c3e6$1@news.swissonline.ch>

hi harald

you have to explain me how you've got this precision!?? with your sql-query I just get the miliseconds:

SYSTIMESTAMP

---

25.08.03 10:01:29,546000 +02:00
25.08.03 10:01:30,265000 +02:00

the amount of microseconds is always null! :-(

thanks
- pascal

Harald Maier wrote:

> Daniel Morgan <damorgan_at_exxesolutions.com> writes:
> 
> 

>>Pascal Ziegler wrote:
>>
>>
>>>Hi,
>>>
>>>I need to measure the duration of a pl/sql-function
>>>in microseconds. Do you know any possibility to do this
>>>measurement with oracle (9i)?
>>>
>>>Thank you for the help. :-)
>>>
>>>- Pascal
>>
>>Look at the timestamp data type. It is as close as you are going to
>>get.

> 
> 
> Here an example:
> 
> ,----
> | SQL> select systimestamp from dual;
> | 
> | SYSTIMESTAMP
> | -------------------------------
> | 23.08.03 09:37:58,501550 +02:00
> `----

Received on Mon Aug 25 2003 - 03:08:30 CDT