Re: how to set seconds-precision for systimestamp

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 20 Apr 2009 20:05:25 +0200
Message-ID: <d1ea3$49ecb965$524b9d64$10365_at_cache4.tilbu1.nb.home.nl>

Ken Quirici wrote:

> On Apr 19, 8:56 pm, Phil H <phil_herr..._at_yahoo.com.au> wrote:

>> This is mentioned in Note 602951.1 in Metalink.
>>
>> Oracle just reads the OS system clock, which under Windows gives the
>> time down to milliseconds, according to the docs for the SYSTEMTIME
>> structure.
>>
>> -- Phil

>
> Darn. Thanks for the info tho!
I thought it was just the default (ff3, that is) Er... no it isn't:

SQL> select systimestamp from dual;
SYSTIMESTAMP

---

20-APR-09 08.01.35.719206 PM +02:00 SQL> /
SYSTIMESTAMP

---

20-APR-09 08.01.39.416713 PM +02:00 SQL> /
SYSTIMESTAMP

---

20-APR-09 08.01.40.549427 PM +02:00 SQL> /
SYSTIMESTAMP

---

20-APR-09 08.01.41.275923 PM +02:00

-- 

Regards,
Frank van Bortel

Received on Mon Apr 20 2009 - 13:05:25 CDT