It would be neat if the sqlite strftime function could support the %U conversion, to give Week of Year, where a week starts on Sunday.
As it is, there's a bit of an impedance mismatch, as %w gives day of week where 0 == Sunday, but the supported %W conversion gives Week of Year, where week starts on Monday. James _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users