Hello,
It seems that at least under windows there are rounding problems with the
milliseconds:
sqlite> select strftime("%f", "2005-01-01 12:34:55.122");
55.121
sqlite> select strftime("%f", "2005-01-01 12:34:55.123");
55.122
sqlite> select strftime("%f", "2005-01-01 12:34:55.124");
55.124
Similar with Julian dates:
sqlite> select strftime("%J", "2005-08-02 08:30:00");
2453584.854166667
Which should be 2453584.85417 as I think.
I've used Sqlite version 3.2.2 (windows).
Is this maybe a problem of the underlying c-library?
Has anyboby an idea how to workaround this?
ivo
