Oops...forgot to add what you want. %U The week number of the current year as a decimal number, range 00 to 53, starting with the first Sunday as the first day of week 01. See also %V and %W.
And this one: %V The ISO 8601:1988 week number of the current year as a decimal number, range 01 to 53, where week 1 is the first week that has at least 4 days in the current year, and with Monday as the first day of the week. See also %U and %W. (SU) But SQLite doesn't implement those. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Denis Burke Sent: Wednesday, June 19, 2013 11:21 AM To: sqlite-users@sqlite.org Subject: [sqlite] First Day of Week Inconsistency The built-in function strftime properly (imho) responds to the '%w' command for day of week with Sunday as day 0. e.g. - strftime ('%w','2013-06-19') -> 3 But the built-in function for returning week of the year treats weeks as though they begin on Monday, not Sunday: e.g. strftime ('%W','2013-06-19') -> 24 strftime ('%W','2013-06-17') -> 24 strftime ('%W','2013-06-16') -> 23 It seems to me these useful functions are inconsistent. Is it possible to modify %W to treat Sunday as the first day of the week? Thanks, Denis Burke _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users