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