On Jun 12, 2008, at 5:22 PM, P Kishor wrote: > On 6/12/08, Shane Harrelson <[EMAIL PROTECTED]> wrote: >> I was able to reproduce this by setting by TZ to GMT +10:00. It's a >> floating point rounding issue in the julian date functions. We're >> investigating how to best correct it, but I don't have a "fix" for >> you now. > > I can reproduce this bug on Mac OS X 10.5.3 with SQLite 3.5.9 without > having to tinker with TZ.
Check-in [5215] (http://www.sqlite.org/cvstrac/chngview?cn=5215) contains test cases that ticket the problem without doing any timezone manipulations, and indeed without invoking the "localtime" modifier. That same check-in contains the fix. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
