Wednesday, August 10, 2005, 5:57:50 AM, Ivo wrote:
IK> Hello,
IK> It seems that at least under windows there are rounding problems with the
IK> milliseconds:
IK> sqlite> select strftime("%f", "2005-01-01 12:34:55.122");
IK> 55.121
IK> [...]
IK> Is this maybe a problem of the underlying c-library?
IK> Has anyboby an idea how to workaround this?
Use a better C library ;-). At least some parts of sqlite use an
internal printf() which does not implement the dragon algorithm.
See:
http://portal.acm.org/citation.cfm?id=989431
http://portal.acm.org/citation.cfm?id=93557
implementations:
http://www.cs.indiana.edu/~burger/fp/
http://netlib.bell-labs.com/netlib/fp/
e
