--- 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:
SQLite version 3.2.2
Enter ".help" for instructions
sqlite> SELECT strftime('%Y-%W', 'now');
2007-01
sqlite> SELECT strftime('%Y-%W', 'now');
2007-01
sqlite> SELECT strftime('%Y-%W', 'now');
2007-02
sqlite> SELECT strftime('%Y-%W', 'now');
2007-02
sqlite> SELECT strftime('%Y-%W', 'now');
2007-02
sqlite> SELECT strftime('%Y-%W', 'now');
2007-01
sqlite> SELECT strftime('%Y-%W', 'now');
2007-01
sqlite> SELECT strftime('%Y-%W', 'now');
2007-01
sqlite> SELECT strftime('%Y-%W', 'now');
2007-02
sqlite> SELECT strftime('%Y-%W', 'now');
2007-02
sqlite> SELECT strftime('%Y-%W', 'now');
2007-01
sqlite> SELECT strftime('%Y-%W', 'now');
2007-02
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
