Re: [sqlite] rounding problems with milliseconds

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

[sqlite] rounding problems with milliseconds

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