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]
-----------------------------------------------------------------------------

Reply via email to