Re: oracle: measurement in microseconds

From: Harald Maier <maierh_at_myself.com>
Date: Mon, 25 Aug 2003 10:17:32 +0200
Message-ID: <m31xvarw0z.fsf@ate.maierh>

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 - 03:17:32 CDT