Re: Time fraction(6) with Oracle 9i on Windows NT

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Fri, 17 Sep 2004 00:38:49 +0100
Message-ID: <qi8kk0d3b3rig1jushhdgn9qc8ud43rmam@4ax.com>

On Thu, 16 Sep 2004 15:35:45 GMT, Kenneth Koenraadt wrote:

>>Can Oracle 9i generate microseconds for timestamp fields
>>on Windows NT?
>>
>>I have a table with one timestamp field.
>>Several inserts of CURRENT time gave following result:
>> 2004-09-15-16.47.11.154000
>
>>May be there is some options that can affect this restriction?
>
>Not AFAIK. Oracle's timestamps are inherited from the O/S.
>
>Solution 1) : Move to a platform which doesn't suffer such problem,
>e.g. Linux.

Windows is capable of offering higher resolution time information; it depends what function you use, and how recent your CPU is for the highest resolution option.

See this article:
http://www.mvps.org/directx/articles/selecting_timer_functions.htm

The always-available basic function (timeGetTime) is only millisecond resolution, so maybe Oracle have just gone for the lowest common denominator solution.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Received on Thu Sep 16 2004 - 18:38:49 CDT