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.
Martin
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
