Re: oracle: measurement in microseconds

From: Pascal Ziegler <pascal.ziegler_at_bluewin.ch>
Date: Mon, 25 Aug 2003 11:06:47 +0200
Message-ID: <3f49d182$1@news.swissonline.ch>

I have expected a such answer! ;) unfortunatelly I have to work on this minor OS! :(

thx
-pascal

Harald Maier wrote:

> Pascal Ziegler <pascal.ziegler_at_bluewin.ch> writes:
> 
> 

>>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! :-(

> 
> 
> Maybe I am working with a superior OS;)? I assume this is OS dependent.
> 
> ,----
> | $ uname -a
> | Linux athene 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 unknown
> `----
> 
> Harald
> 
> 

>>Harald Maier wrote:
>>
>>>Here an example:
>>>,----
>>>| SQL> select systimestamp from dual;
>>>| | SYSTIMESTAMP
>>>| -------------------------------
>>>| 23.08.03 09:37:58,501550 +02:00
>>>`----
Received on Mon Aug 25 2003 - 04:06:47 CDT