Martin Jenkins <[EMAIL PROTECTED]> wrote: > Joe Wilson wrote: > > --- Will Leshner <[EMAIL PROTECTED]> wrote: > > > >> In the current release of SQLite (3.3.9) I find that if I execute the > >> following query multiple times in succession I get different values > >> for %W: > >> > >> SELECT strftime('%Y-%W', 'now'); > >> > >> Sometimes the value is '2007-02' and other times the value is > >> '2007-01'. If this sounds like a bug, I'll file a bug report. > >> > > > > This problem appears to be pretty old: > > > In date.c near line 921 > > nDay = x.rJD - y.rJD; > > is liable to FP rounding errors and needs to be changed to > > nDay = (int)(x.rJD - y.rJD + 0.5); > > I've done some cursory tests but the full test suite hasn't finished yet. >
See http://www.sqlite.org/cvstrac/chngview?cn=3570 -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------