--- [EMAIL PROTECTED] wrote:
> A double is sufficient to store the current time to with about
> 25 microseconds.  If you use 'now' to get the current time, the
> date functions try to capture the current time to this precision.
> That is implemented in the os_XXX.c layer.  It's system dependent.
> Check to see what your system is doing.

Useless trick to find out the minimum resolution of your machine's clock
using only sqlite...

create view v1 as select 1 union all select 2 union all select 3;
select distinct julianday('now') from v1,v1,v1,v1,v1,v1,v1,v1,v1,v1,v1;
2454152.64735713
2454152.64735731
2454152.64735749
2454152.64735768
2454152.64735786
2454152.64735804
2454152.64735822
2454152.6473584
2454152.64735858
2454152.64735876
2454152.64735894
2454152.64735912
2454152.6473593
2454152.64735948
2454152.64735967
2454152.64735985
2454152.64736003
2454152.64736021
2454152.64736039
2454152.64736057
2454152.64736075
2454152.64736093
2454152.64736111
2454152.64736129
2454152.64736147

sqlite> select (2454152.64736147 - 2454152.64736129) * 24 * 60 * 60;
0.015529990196228

So this machine's minimum timer resolution is 0.0155 seconds, 
or 15.5 milliseconds.



 
____________________________________________________________________________________
Bored stiff? Loosen up... 
Download and play hundreds of games for free on Yahoo! Games.
http://games.yahoo.com/games/front

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to