On 04 May 2019, at 09:35, Olivier Mascia <o...@integral.be> wrote: >> Le 2 mai 2019 à 22:01, Thomas Kurz <sqlite.2...@t-net.ruhr> a écrit : >> >> I think "week of the month" is not a standard value. As with week of the >> year, is week #1 the week in which the month starts, the first complete week >> within the month, or the first week with at least 4 days? > > These are very regional matters around our living globe. > In most European locations where ISO-8601 applies for that matter, a week > starts on Monday and ends on Sunday (not Sunday to Saturday) and the week #1 > of a year is the one week whose Thursday falls in that year (and the Monday > can be in the previous year). This can lead to years sometimes with 53 weeks > instead of 52.
It can also be a personal matter. For me, the week starts on Monday. For my wife, it starts on Sunday. -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users