In ISO the weeks are indeed from Monday (1) to Sunday (7) and all days between a Monday and Sunday belong to the same week.
The first week (1) of a year is the one containing the first Thursday of the year. Or said differently containing the 4th of January. This implies that : week 1 can start in the year-1 and there can be a week 53 some years. -- Best regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia (from mobile device), http://integral.software > Le 18 mai 2017 à 07:31, John McMahon <li...@jspect.fastmail.fm> a écrit : > > Sorry, re-sending to list. > > Point of Clarification: The ISO Week begins as day 1 on Monday and ends as > day 7 on Sunday, hump day (colloq.) is Thursday. There may be other > repercussions in terms of week counts if this has not been implemented > correctly. I haven't checked, I do not use this personally. > > John > > > > >> On 17/05/2017 19:07, no...@null.net wrote: >> The current '%W' week substitution appears to be US-specific. I would >> like to make a feature request for a '%V' (or similar) substitution >> that inserts the ISO-8601 week number. > > -- > Regards > John McMahon > li...@jspect.fastmail.fm > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users